Closed macdi011 closed 7 months ago
Dml Check point
SELECT FROM produits; INSERT INTO produits VALUES('cookies' ,'10') , ('candy' , 5); SELECT FROM produits; CREATE TABLE clients( nom varchar(25), adresse varchar(25) ); INSERT INTO clients VALUES('ahmed' ,'tunisie') ,('coulibaly' ,'senegal') ,('hasan' ,'egypte'); SELECT FROM clients; CREATE TABLE commandes( costumer_id INT, product_id INT, Quantity INT, order_date DATE ); INSERT INTO commandes(costumer_id, product_id, Quantity, order_date) VALUES (1, 2 ,3 , '2023-01-22') , (2 ,1, 10 , '2023-04-14'); SELECT FROM commandes;
Dml Check point
SELECT FROM produits; INSERT INTO produits VALUES('cookies' ,'10') , ('candy' , 5); SELECT FROM produits; CREATE TABLE clients( nom varchar(25), adresse varchar(25) ); INSERT INTO clients VALUES('ahmed' ,'tunisie') ,('coulibaly' ,'senegal') ,('hasan' ,'egypte'); SELECT FROM clients; CREATE TABLE commandes( costumer_id INT, product_id INT, Quantity INT, order_date DATE ); INSERT INTO commandes(costumer_id, product_id, Quantity, order_date) VALUES (1, 2 ,3 , '2023-01-22') , (2 ,1, 10 , '2023-04-14'); SELECT FROM commandes;