hXXfqYK4

1DROP DATABASE IF EXISTS manager_viewDB;
2
3CREATE DATABASE manager_viewDB;
4use manager_viewDB;
5CREATE TABLE products (
6item_id INT(11) NOT NULL AUTO_INCREMENT, 
7item_name VARCHAR(20) CHARACTER SET utf8,
8department_name varchar(50) DEFAULT NULL,
9item_price INT(11) DEFAULT NOT NULL,
10item_quantity int(11) DEFAULT NOT NULL,
11PRIMARY KEY (item_id)
12);
13
14
15
16
17SELECT * FROM products;
18INSERT INTO products (item_name, department_name, item_price, item_quantity)
19VALUES("Mini Mac", "Computers", 689, 10);
20SELECT * FROM products;
21INSERT INTO products (item_name, department_name, item_price, item_quantity)
22VALUES("ECHO plus", "Amazon Devices", 79.99, 10);
23SELECT * FROM products;
24INSERT INTO products (item_name, department_name, item_price, item_quantity)
25VALUES("Funny Cat Mug", "Handmade", 20, 10);
26SELECT * FROM products;
27INSERT INTO products (item_name, department_name, item_price, item_quantity)
28VALUES("Wine Barell Top Mirror", "Home and Kitchen", 328, 10);
29SELECT * FROM products;
30INSERT INTO products (item_name, department_name, item_price, item_quantity)
31VALUES("Hand Stamped Bracelets", "Wedding", 20, 10);
32SELECT * FROM products;
33INSERT INTO products (item_name, department_name, item_price, item_quantity)
34VALUES("Kawaii - Animal Plush", 22, 10);
35SELECT * FROM products;
36INSERT INTO products (item_name, department_name, item_price, item_quantity)
37VALUES("Weave Blanket - MDA",   "Handmade", 60, 10);
38SELECT * FROM products;
39INSERT INTO products (item_name, department_name, item_price, item_quantity)
40VALUES("Retro Tiki - Cellphone", "Handbags and Accessories", 22, 10);
41SELECT * FROM products;
42INSERT INTO products (item_name, department_name, item_price, item_quantity)
43VALUES("Handmade Leather Bag", "Handbags and Accessories", 70, 10);
44SELECT * FROM products;
45INSERT INTO products (item_name, department_name, item_price, item_quantity)
46VALUES("Devialet Gold Phantom", "Electronics", 2990, 10);