Sql create a new table

This article is tagged with: Sql create a new table and mysql

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;

This article is tagged with: Sql create a new table and mysql