sql table
CREATE TABLE utilisateur
(
 id INT PRIMARY KEY NOT NULL,
  nom VARCHAR(100),
  prenom VARCHAR(100),
  email VARCHAR(255),
date_naissance DATE,
pays VARCHAR(255),
ville VARCHAR(255),
code_postal VARCHAR(5),
nombre_achat INT
)
SQL create a new table
CREATE TABLE table_name
(
column1 TYPE [COLUMN CONSTRAINTS],
column2 TYPE [COLUMN CONSTRAINTS],
column3 TYPE [COLUMN CONSTRAINTS],
[TABLE CONSTRAINTS...]
);
create table
CREATE TABLE fact (
id SERIAL PRIMARY KEY NOT NULL,
type VARCHAR(255),
text TEXT
);
create table sql
# Simple table describing a vehicle
CREATE TABLE vehicle(
# vehicleId: Unique ID for Primary Key.
# This is how we will reference a record
vehicleId INT NOT NULL,
make VARCHAR(64), # String 64 chars max
model VARCHAR(128),
derivative VARCHAR(255),
PRIMARY KEY(vehicleId)
);
# Add a record
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
sql create table with columns as another table
SELECT * INTO newtable FROM oldtable WHERE 1 = 0;
