Stack Overflow
Stack Overflow

Questions tagged [database-table]

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

In a relational database management system (RDBMS) a table organizes the information in rows and columns. Each table has a defined number of columns, each of which is identified by its name, but the number of rows is variable, consisting of one for each line of data.

More Information:

  1. The wiki entry on database tables is a good source of information.
  2. Microsoft provides an intuitive definition of a table
313 questions
1
vote
1 answer

Unable to write back changes to an access database after a table merge

I have an access database containing a table called 'Items'. I have a number of smaller databases that also contain a table 'Items'. They each have a primary key called 'ID' and there are no duplicates. The following code appears to merge…
Andy Powell
  • 583
  • 1
  • 6
  • 15
1
vote
1 answer

Hbase Table not deleted from Phoenix

I have created table in hbase via phoenix. Why hbase table is not droped after deleted it from Phoenix and vise versa.? Why deleting a table from Phoenix takes considerably more time than deleting it from Hbase directly?
Jobs
  • 1,257
  • 2
  • 14
  • 27
1
vote
2 answers

Using empty tables NAV 2009 R2

I'm no NAV professional nor got any experience with NAV. Since 1 week I'm working with NAV and I got several questions about it, but I think that those "Microsoft specialized" experts my new employer is working with are just fooling us. They for…
PoscheL
  • 73
  • 9
1
vote
1 answer

Quickest Way to Add New Rows to Datatable That Could Contain Duplicates

I have a table full of stock price data. Each row has a unique combination of Ticker symbols and dates. I load new data all the time by obtaining CSV files containing stock price data for everyday for every ticker. I know that there are…
gromit1
  • 577
  • 2
  • 14
  • 36
1
vote
1 answer

Creating MYSQL Database Table? Need Help Revising

I've created a login system. I have SOME knowledge of MYSQL and I would like to have this big junk of code revised. This is the code: DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS Country; CREATE TABLE Country( country_code …
user2647319
  • 39
  • 6
1
vote
1 answer

MS SQL is this possible to do in a view?

I have 4 tables: table A: |LineID| table B: |Date|ShiftID|IsWorking| Table C: |LineID|Date|ShiftID|IsWorking| Table D: |ShiftID|HowLongWorks| I need to create a view where I will have |LineID|Date|HowLongWorks| In this view I need to have: -…
user1736332
  • 693
  • 4
  • 11
  • 22
1
vote
0 answers

Concurrency violation: the UpdateCommand when calling DataAdapter.Update()

I have a data table to update changes to DataBase table. For better understanding what I mean I posted the picture. How can solve this problem? When I delete the row I call rows.Delete() method. When I click Save button on the form it will call…
deva
  • 123
  • 1
  • 2
  • 9
1
vote
9 answers

How to store data that can be structured or non-structured at the same time?

I have a database with the following table: PATIENT (PATIENT_ID*, MEDICAL_EXAMINATIONS) where the field MEDICAL_EXAMINATIONS contains a free-text description of the exams undertaken by the patient. Recently, it was decided that medical examination…
Hobbes
  • 978
  • 2
  • 9
  • 15
1
vote
1 answer

Creating SQL table, foreign_key confusion

One question, I have supervisor set as foreign key. He collect information through Activity Participant and take it from person ID. Question: How should I create the Activity table? what do I have to write down about supervisor? CREATE TABLE…
Denis Nurasy
  • 41
  • 1
  • 8
1
vote
1 answer

Trying to automatically insert a foreign key value into my mysql table

I am new with PHP and MySQL and need help... Im cant seem to get my head around how to automatically insert a foreign key into a table in my database. The primary key gets added as 'id' in my 'mem' table but I want this same id to be added to a…
user2003341
  • 73
  • 1
  • 9
1
vote
0 answers

satchmo no such table

When ever i goto the admin and click i on any of the satchmo links i get DatabaseError at /admin/product/category/ no such table: product_category Request Method: GET Request URL: url.com/admin/product/category/ Django Version: 1.3.1 Exception…
user1848114
  • 19
  • 2
1
vote
1 answer

SQL query with different counts

I am trying to write a SQL query in Delphi, but yet without luck. I have two tables, the first one holds personal data, the second one holds information about purchased goods. My query works fine when I connect the two tables with WHERE clause (my…
Yohnsee
  • 33
  • 1
  • 4
1
vote
2 answers

Create SQL Table in PHP with variables and text

I'm trying to create a SQL table in PHP using the following code: $sql = "CREATE TABLE `$DBName`.`$login`_clients ( ClientID int NOT NULL AUTO_INCREMENT, PRIMARY KEY (`ClientID`), AgentClients varchar(15), ClientTotal int )"; The…
Blaine Hurtado
  • 139
  • 2
  • 17
1
vote
1 answer

How do I move one table to another if there is not already a match of one of the fields

I am having trouble getting things moved in a database. I have two tables with different column names the one that is the same name is "zip" but they have the same data. I want to move from table A to table b if the zip code doesn't already exist in…
user1375893
  • 13
  • 3
1
vote
2 answers

Should I have less tables and use complex queries to fetch data or have more tables to simplify queries?

Let's take a senario where user is tracking traffic for certain cities. The traffic is updated every two hours and we've to keep previous data to plot graph. So I've a traffic_stats table which looks like this…
Apoorv Parijat
  • 861
  • 1
  • 10
  • 16
1 2 3
…
20 21