MySQL——创建cap表

CREATE TABLE CUSTOMERS(cid char(5) Primary Key, cname varchar(20) NOT NULL, city char(20), discnt decimal(4,2))
CREATE TABLE AGENTS(aid char(5) Primary Key, aname varchar(20) NOT NULL, city char(20),per int )
CREATE TABLE PRODUCTS(pid char(5) Primary Key, pname varchar(20) NOT NULL,city char(20), quantity int,price decimal(3,2) )
CREATE TABLE ORDERS(ordno char(5) Primary Key,month char(5),cid char(5),aid char(5),pid char(5),qty int,dollars decimal(6,2))

INSERT INTO CUSTOMERS VALUES ('c001', 'TipTop','Duluth',10.00)
INSERT INTO CUSTOMERS VALUES ('c002', 'Basics','Dallas', 12.00)
INSERT INTO CUSTOMERS VALUES ('c003', 'Allied','Dallas',8.00)
INSERT INTO CUSTOMERS VALUES ('c004', 'ACME','Duluth',8.00)
INSERT INTO CUSTOMERS VALUES ('c006', 'ACME','Kyoto',0.00)


INSERT INTO AGENTS VALUES ('a01','Smith','New York',6)
INSERT INTO AGENTS VA