SQL

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 table

CREATE TABLE users ( ) 

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.

sql table

create table SUBSCRIPTION (
-> MSISDN int(13),
-> PRODUCT_ID int(7),
-> EFFECTIVE_DATE date&time,
-> EXPIRED_DATE date&time );