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
0 answers

Compare columns in CSV with columns in database table in JAVA

I have a CSV with 44 columns and I have a table with 21 columns. Need to check of the columns in CSV along with the data matches with columns and data in database table I have created 2 class (one with main) where I have read the CSV file and stored…
Dolly
  • 97
  • 3
  • 18
1
vote
1 answer

Count rows in all schemas (with permission granted) in all tables

I'm trying to count the rows in all the tables in the database. Since the answer I'd like to get must differentiate between different schemas I also take into account the schema that a particular table is located in. This answer has been most…
balkon16
  • 1,338
  • 4
  • 20
  • 40
1
vote
3 answers

Wrong TimeZone in DataTable

I Have a web site, which is on server1. It uses web service, which is on server2. Web service uses database, which is on server3. Server1 server2 and server3 has different timezone, so when I get datatable via web service, Datetime type column has…
Vano Maisuradze
  • 5,829
  • 6
  • 45
  • 73
1
vote
1 answer

Monitoring progress of a SQL script with many UPDATEs in MariaDB

I'm running a script with several million update statements like this: UPDATE data SET value = 0.9234 WHERE fId = 47616 AND modDate = '2018-09-24' AND valueDate = '2007-09-01' AND last_updated < '2018-10-01'; fId, modDate and valueDate are the 3…
Adam
  • 5,215
  • 5
  • 51
  • 90
1
vote
1 answer

PHP: Function to plot any query result in a table

I'm relatively new to using PHP and have been working on using it to fetch data from a database. I have been able to plot queries in tables quite easily when I know the number of columns that need to be plotted, like below: echo "
JonnyIrving
  • 753
  • 2
  • 8
  • 18
1
vote
1 answer

mysql db table query

i have two tables: users{user_id, username, picture} likes{id, user_id, image_id} the query im trying to do is: select username, picture from user and from likes where user_id=user_id and image_id=4 but i dnt know how to connect them, thanks
getaway
  • 8,792
  • 22
  • 64
  • 94
1
vote
4 answers

Where did my new table go

I have a database called mbt. I wanted to write some data from temporary table to real table. --I used this query. SELECT * INTO new_table FROM #tmp when i runned the query it returned normal message. 15813 row(s) affected After that i…
Gork. O
  • 65
  • 7
1
vote
1 answer

Mysql primary key when using INSERT INTO ... ON DUPLICATE KEY UPDATE

My table structure is: CREATE TABLE IF NOT EXISTS `users_settings_temp` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` int(10) unsigned DEFAULT NULL, `type` enum('type1','type2') `data` text, `date_created` int(11) DEFAULT…
webdev_007
  • 121
  • 3
  • 5
  • 9
1
vote
1 answer

Error creating table in MySQL database using C#

This error occurs whenever i'm trying to run my program. Additional information: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 The code is as…
Annie
  • 29
  • 2
1
vote
2 answers

Billing address WooCommerce database table

I would like to know, what database table is WooCommerce using for the Billing Address for each user? I really need to know, because I need to import users from another database. Thanks.
Eson Roxas
  • 43
  • 1
  • 10
1
vote
0 answers

SQLServer Table Partitioning

While using partition table SQL feature, I ’ve experienced strange behaviour. It seems that it’s better to insert rows into the table with while loop than inserting rows into the temporary table, and then at once insert from temporary table to…
Exerlol
  • 241
  • 3
  • 14
1
vote
1 answer

Get table names from POSTGIS database with PyQGIS

How can I access the table names inside a POSTGIS database with PyQGIS? I am trying to load a layer from A POSTGIS database. I can do it if I know the table's name which I am gonna use.
okorkut
  • 491
  • 2
  • 12
1
vote
3 answers

With ODP.NET, Create C# class/struct from Column Info of an Oracle DB's Table

Is there an established way/tool to automatically create generate C# class/struct containing the variables according to the columns of an Oracle DB's Table? I currently am using ODP.Net to handle a number of Tables from Oracle DB. To ease me to…
Ian
  • 30,182
  • 19
  • 69
  • 107
1
vote
4 answers

SQL Server, Unused tables for a long time (How to get rid of unnecessary tables)?

Is there a way to find the unused tables which are nothing else but rubbish in database?
stckvrflw
  • 1,489
  • 3
  • 22
  • 37
1
vote
0 answers

Insert Table Field Values from Dictionary Values with corresponding Keys

Would it be be possible to insert dictionary values, one at a time into a specific field/column of a sqlite3 database table? The fields/columns were created with the database in a previous step. I would prefer to use a for loop, but I haven't found…
St4rb0y
  • 317
  • 3
  • 5
  • 22
1 2 3
…
20 21