Scribd
Upload
17 views1 page

Code

The document contains SQL insert statements for three tables: customers, products, and orders. It adds five customers with their details, five products with their prices, and five orders linking customers to products with quantities and order dates. This data setup is likely for a database related to a retail or e-commerce system.

Uploaded by

tanyibesong576
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
17 views1 page

Code

The document contains SQL insert statements for three tables: customers, products, and orders. It adds five customers with their details, five products with their prices, and five orders linking customers to products with quantities and order dates. This data setup is likely for a database related to a retail or e-commerce system.

Uploaded by

tanyibesong576
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

INSERT INTO customers(customer_id, customer_name, address)

VALUES('C1507', 'MAFON BETILA', 'Bamenda'),


('C1517', 'KIMBONG BLESS', 'Kumba'),
('C1523', 'MOYANCHO MALVIN', 'Yaounde'),
('C1525', 'NDINTECK ALEX', 'Bamenda'),
('C1557', 'DINSE JOSHUA', 'Buea');

INSERT INTO products(product_id, product_name, unit_price)


VALUES ('PR01', 'White Rice', '21000'),
('PR02', 'ELENA Tomatoe', '5400'),
('PR03', 'Mayor-Vegetable oil', '18000'),
('PR04', 'SuperJus', '3000'),
('PR05', 'NIPE-Sardine', '2500');

INSERT INTO orders(customer_id, product_id, order_id, quantity, order_date)


VALUES( 'C1507', 'PR02', 'CR01', '10', '2020-12-14'),
('C1507', 'PR05', 'CR01', '5', '2020-12-14'),
( 'C1507', 'PR01', 'CR01', '10', '2020-12-14'),
( 'C1523', 'PR05', 'CR02', '8', '2020-12-16'),
('C1523', 'PR03', 'CR03', '4', '2020-12-20');

You might also like