database-table Archives

postgresql, Programming

IT Nursery

I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? ...

MySQL, Programming

IT Nursery

What is the upper limit of records for MySQL database table. I’m wondering about autoincrement field. What would happen if I add milions ...

Database, Programming

IT Nursery

This is probably a n00blike (or worse) question. But I’ve always viewed a schema as a table definition in a database. This is ...

In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; … other stuff … and then you can run ...

I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect and USE the ...

I know the statement: create table xyz_new as select * from xyz; Which copies the structure and the data, but what if I ...

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I ...

I want to create a table in a SQLite database only if doesn’t exist already. Is there any way to do this? I ...

I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to ...

I’m looking for a way to find the row count for all my tables in Postgres. I know I can do this one ...