· 8 years ago · Dec 22, 2017, 08:28 PM
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);