编辑代码

CREATE DATABASE test;
use test;
-- 销售表
CREATE TABLE sale (
  MNO varchar(255),
  PNO varchar(255) ,
  QTY varchar(255) ,
  COST varchar(255) ,
  SALE varchar(255) 
);
INSERT INTO sale VALUES ('1101', '0020', '30', '300', '360');
INSERT INTO sale VALUES ('1101', '0002', '3', '3.9', '5.7');
INSERT INTO sale VALUES ('1102', '0020', '35', '385', '445');
INSERT INTO sale VALUES ('1103', '0022', '33', '33', '36.3');
INSERT INTO sale VALUES ('1103', '0024', '25', '12.5', '15');
INSERT INTO sale VALUES ('1104', '0023', '34', '3400', '4080');
INSERT INTO sale VALUES ('1101', '0002', '3', '3.9', '5.7');

CREATE TABLE store (
  MNO varchar(255),
  MNAME varchar(255),
  CITY varchar(255),
);
INSERT INTO store VALUES ('101', '南区', '上海');
INSERT INTO store VALUES ('102', '北区', '上海');
INSERT INTO store VALUES ('103', '西区', '上海');
INSERT INTO store VALUES ('104', '东区', '上海');
INSERT INTO store VALUES ('105', '南区', '苏州');
INSERT INTO store VALUES ('106', '北区', '苏州');

-- 商品表
CREATE TABLE gds (
  PNO varchar(11),
  PNAME varchar(255),
  CITY varchar(255),
  COLOR varchar(255)
);

INSERT INTO gds VALUES ('0001', '橡皮1', '上海', '红色1');
INSERT INTO gds VALUES ('0002', '橡皮2', '上海', '红色2');
INSERT INTO gds VALUES ('0003', '橡皮3', '上海', '红色3');
INSERT INTO gds VALUES ('0004', '橡皮4', '上海', '红色4');
INSERT INTO gds VALUES ('0005', '橡皮5', '上海', '红色5');
INSERT INTO gds VALUES ('0006', '橡皮6', '上海', '红色6');
INSERT INTO gds VALUES ('0007', '橡皮7', '上海', '红色7');
INSERT INTO gds VALUES ('0008', '橡皮8', '上海', '红色8');
INSERT INTO gds VALUES ('0009', '橡皮9', '上海', '红色9');
INSERT INTO gds VALUES ('0010', '橡皮10', '上海', '红色10');
INSERT INTO gds VALUES ('0011', '橡皮11', '上海', '红色11');
INSERT INTO gds VALUES ('0012', '橡皮12', '上海', '红色12');
INSERT INTO gds VALUES ('0013', '橡皮13', '上海', '红色13');
INSERT INTO gds VALUES ('0014', '橡皮14', '上海', '红色14');
INSERT INTO gds VALUES ('0015', '橡皮15', '上海', '红色15');
INSERT INTO gds VALUES ('0016', '橡皮16', '上海', '红色16');
INSERT INTO gds VALUES ('0017', '橡皮17', '上海', '红色17');
INSERT INTO gds VALUES ('0018', '橡皮18', '上海', '红色18');
INSERT INTO gds VALUES ('0019', '橡皮19', '上海', '红色19');
INSERT INTO gds VALUES ('0020', '橡皮20', '上海', '红色20');
INSERT INTO gds VALUES ('0021', '橡皮21', '上海', '红色21');
INSERT INTO gds VALUES ('0022', '橡皮22', '上海', '红色22');
INSERT INTO gds VALUES ('0023', '橡皮23', '上海', '红色23');
INSERT INTO gds VALUES ('0024', '橡皮24', '上海', '红色24');
INSERT INTO gds VALUES ('0025', '橡皮25', '上海', '红色25');

select * from gds;
select * from store;
select * from sale;