python_programming_/sql/create-db-inventory.sql at main · machphy/python_programming_ · GitHub

23 lines (20 loc) · 1.02 KB

DROP DATABASE IF EXISTS `sql_inventory`;

CREATE DATABASE `sql_inventory`;

USE `sql_inventory`;

CREATE TABLE `products` (

`product_id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL,

`quantity_in_stock` int(11) NOT NULL,

`unit_price` decimal(4,2) NOT NULL,

PRIMARY KEY (`product_id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `products` VALUES (1,'Foam Dinner Plate',70,1.21);

INSERT INTO `products` VALUES (2,'Pork - Bacon,back Peameal',49,4.65);

INSERT INTO `products` VALUES (3,'Lettuce - Romaine, Heart',38,3.35);

INSERT INTO `products` VALUES (4,'Brocolinni - Gaylan, Chinese',90,4.53);

INSERT INTO `products` VALUES (5,'Sauce - Ranch Dressing',94,1.63);

INSERT INTO `products` VALUES (6,'Petit Baguette',14,2.39);

INSERT INTO `products` VALUES (7,'Sweet Pea Sprouts',98,3.29);

INSERT INTO `products` VALUES (8,'Island Oasis - Raspberry',26,0.74);

INSERT INTO `products` VALUES (9,'Longan',67,2.26);

INSERT INTO `products` VALUES (10,'Broom - Push',6,1.09);

Expand file tree