UFzWPLVU

1-- DROP SCHEMA IF EXISTS `tutorial`;
2-- DROP TABLE `tutorial`.`product` ;
3-- create schema `tutorial`;
4-- USE `tutorial`;
5
6
7-- CREATE TABLE IF NOT EXISTS `tutorial`.`product`(
8--   `id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
9--   `name` VARCHAR(40) DEFAULT NULL,
10--   `deproductscription` VARCHAR(255) DEFAULT NULL,
11--   `unit_price` DECIMAL(13,2) DEFAULT NULL,
12--   `units_in_stock` INT(11) DEFAULT NULL 
13--   )
14  
15  INSERT INTO tutorial.product 
16  (name,description,unit_price,units_in_stock)
17  VALUES
18  ('banan','świeży',3.20,6),
19  ('butelka wody','niegazowana',1.00,1),
20  ('ser','żółty',10.99,1),
21  ('ser','biały',16.99,1),
22  ('mleko','3,2% ',10.99,1),
23  ('Monster Energy nap. energ. 500ml', 'ORIGINAL', 4.99, 20),
24  ('Monster Energy nap. energ. 500ml', 'THE DOCTOR', 4.99, 20),
25  ('Level Up nap. energ. 250ml', 'CLASSIC', 1.99, 30),
26  ('Level Up nap. energ. 250ml', 'MANGO', 1.99, 30);
27  
28  
29  DELETE FROM tutorial.product
30  WHERE id = 1;