Top "Create-table" questions

The statement that creates a table in SQL (`CREATE TABLE ...`).

Create a temporary table in a SELECT statement without a separate CREATE TABLE

Is it possible to create a temporary (session only) table from a select statement without using a create table statement …

mysql select temp-tables create-table derived-table
Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table

After googling around, I cannot find a way to create a new table with a DATETIME column with the default …

mysql datetime command-line format create-table
Field 'id' doesn't have a default value?

I am new to this SQL; I have seen similar question with much bigger programs, which I can't understand at …

mysql insert create-table
PostgreSQL create table if not exists

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

sql postgresql ddl create-table database-table
#1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

I'm new to PHP and MySQL and ran into a little trouble with a learning project I'm working on. Whenever …

mysql error-handling create-table
Create table in SQLite only if it doesn't exist already

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to …

sqlite create-table database-table
How do I create a table based on another table

I want to create a table based on the definition of another table. I'm coming from oracle and I'd normally …

sql-server sql-server-2008 create-table
MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB

I want to create a table of 325 column: CREATE TABLE NAMESCHEMA.NAMETABLE ( ROW_ID TEXT NOT NULL , //this is the …

mysql sql create-table
Creating new table with SELECT INTO in SQL

Possible Duplicate: SELECT INTO using Oracle I have came across SQL SELECT INTO statement for creating new table and also …

sql oracle select create-table
create table in postgreSQL

I do not understand what is wrong with this query? Query tool does not want to create a table in …

postgresql create-table