database-table Questions
4
Solved
I am trying to design a user table for MySQL.
for now, my user table looks like this
users (
BIGINT id,
VARCHAR(?) username,
VARCHAR(?) password,
VARCHAR(254) email,
DATETIME last_login,
DATETIME...
Solitary asked 11/4, 2011 at 12:45
10
Solved
I store various user details in my MySQL database. Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manip...
Mutilate asked 14/7, 2009 at 12:17
5
Solved
I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries.
But how can I list all tables in the database? And preferably all column and column types.
Lupulin asked 4/2, 2011 at 9:52
17
How to take table-level backup (dump) in MS SQL Server 2005/2008?
Nyala asked 25/3, 2009 at 7:31
15
Solved
I have a table:
table votes (
id,
user,
email,
address,
primary key(id),
);
How can I make the columns user, email, address unique - i.e., ensure that there isn't any pair of rows that has id...
Disoperation asked 11/3, 2009 at 19:12
18
Solved
Is it possible to search every field of every table for a particular value in Oracle?
There are hundreds of tables with thousands of rows in some tables so I know this could take a very long time ...
Coreen asked 16/10, 2008 at 13:14
10
Solved
I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.
Horsefly asked 24/2, 2011 at 20:24
5
I need a simple way to export data from an SQLite database of multiple tables, then import them into another database.
Here is my scenario. I have 5 tables: A, B, C, D, E.
Each table has a primar...
Tectonic asked 8/12, 2010 at 16:41
29
Solved
What's the equivalent to show tables (from MySQL) in PostgreSQL?
Alvertaalves asked 20/4, 2009 at 19:7
1
I put and did not put AUTOINCREMENT for id in person table as shown below:
CREATE TABLE person (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT # ↑↑↑↑↑↑↑↑↑↑↑↑↑
);
CREATE TABLE person (
id INT...
Spiegelman asked 30/9, 2023 at 4:28
18
Solved
This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database c...
Willamina asked 18/11, 2008 at 13:41
21
Solved
I'm looking for a way to find the row count for all my tables in Postgres. I know I can do this one table at a time with:
SELECT count(*) FROM table_name;
but I'd like to see the row count for a...
Jaymie asked 7/4, 2010 at 23:51
7
Solved
In oracle, to drop all tables and constraints you would type something like
DROP TABLE myTable CASCADE CONSTRAINTS PURGE;
and this would completely delete the tables and their dependencies. What...
Joe asked 1/2, 2011 at 3:11
15
Solved
How can I import a CSV file into a MySQL table? I would like for the first row of data be used as the column names.
I read How do I import CSV file into a MySQL table?, but the only answer was to u...
Measurable asked 18/6, 2012 at 6:22
25
I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist.
This Stackoverflow entry suggests doing the select
...
Chauffer asked 3/6, 2009 at 20:59
6
I have a list of numbers, say {2,4,5,6,7}
I have a table, foos, with foos.ID, including say, {1,2,3,4,8,9}
Id like to take my list of numbers, and find those without a counterpart in the ID field ...
Ecospecies asked 7/11, 2008 at 21:0
34
I changed the datadir of a MySQL installation and all the bases moved correctly except for one.
I can connect and USE the database. SHOW TABLES also returns me all the tables correctly, and the fi...
Cargian asked 13/10, 2011 at 19:7
10
Solved
How to select all rows in one table that do not appear on another?
Table1:
+-----------+----------+------------+
| FirstName | LastName | BirthDate |
+-----------+----------+------------+
| Tia |...
Fennell asked 1/8, 2012 at 21:4
7
Solved
I need to send a SQL query to a database that tells me how many rows there are in a table. I could get all the rows in the table with a SELECT and then count them, but I don't like to do it this wa...
Sclerenchyma asked 7/3, 2015 at 16:11
9
Solved
So, I have a script that adds extended properties, some describing a table, some describing a column. How can I check if the extended property exists before adding it so that the script does not th...
Osprey asked 18/6, 2013 at 15:44
14
Solved
I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL?
At the moment I've managed to come up with a SQL statement that returns a...
Mackenie asked 13/5, 2010 at 18:4
20
Solved
What is the best way to get the names of all of the tables in a specific database on SQL Server?
Mier asked 6/10, 2008 at 17:53
17
Solved
If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first?
GO
IF OBJECT_ID('dbo.[Course]','U') IS NOT N...
Wellread asked 21/11, 2009 at 17:15
1
Solved
On SQLite, I displayed the table "user" as shown below but "Null" is not displayed so I cannot differentiate between "Null" and Blank(Empty String):
sqlite> .header...
Amyl asked 17/5, 2022 at 3:46
8
Solved
I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to move (data and all) to database bar from database foo. What is the SQL statement to do ...
Orthotropic asked 9/10, 2008 at 15:20
1 Next >
© 2022 - 2024 — McMap. All rights reserved.