1CREATE TABLE utilisateur
2(
3 id INT PRIMARY KEY NOT NULL,
4 nom VARCHAR(100),
5 prenom VARCHAR(100),
6 email VARCHAR(255),
7 date_naissance DATE,
8 pays VARCHAR(255),
9 ville VARCHAR(255),
10 code_postal VARCHAR(5),
11 nombre_achat INT
12)
1It's a table which structured with a
2set number of columns and a boundless
3number of rows. Table contains data
4and stores the data in databases.
5Once we change information in data
6it changes in the view aswell.