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
)

Source: sql.sh

Tables in sql

It's a table which structured with a
set number of columns and a boundless
number of rows. Table contains data
and stores the data in databases.
Once we change information in data
it changes in the view aswell.

Similar codes

2 votes157 views3 answers
Copy data from one table column to another table column in sql
SQL
18 votes145 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
22 votes168 views3 answers
Sql cheat sheet
SQL
1 vote136 views1 answer
Sql restore backup query
SQL
1 vote138 views1 answer
Sql avg group by
SQL
2 votes133 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote144 views1 answer
Mariadb mysql root access denied
SQL
0 vote175 views1 answer
Suhaib
SQL
1 vote155 views1 answer
Query for all indexes in table postgres
SQL
0 vote134 views1 answer
INSERT INTO table using OpenQuery
SQL