sql query table code example

Example 1: 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
)

Example 2: sql select

Everything in brackets is optional.
SELECT [all/distinct] <COL1>, <COL2>, <COL3>
FROM <TABLE_NAME>
[JOIN <JOIN_CONDITION>]
[WHERE <CONDITION>]
[GROUP BY <COLUMN_NAME>]
[HAVING <SEARCH_CONDITION>]
[ORDER BY <SORT_SPECIFICATION>]

Example 3: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;

Tags:

Sql Example

Related