编辑代码

CREATE DATABASE test;
use test;
/*
CREATE TABLE TABLE4 (
	STOCK varchar(200),
	SYMBOL char(6),
	SHARETYPE char(1),
	PRICE char(255),
    PROVINCE char(10)
);

INSERT INTO TABLE4 (STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE)
    VALUES ('平安银行','000001','A','69.97','广东省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('长安B','200625','B','7.11','重庆市');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('比亚迪','002594','A','172.78','广东省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('东信B','900941','B','0.47','浙江省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('复星医药','600196','A','65.00','上海市');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('ST星源','000005','A','1.82','广东省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('北京城乡','600861','A','14.38','北京市');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('三环集团','300408','A','37.41','广东省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('万科A','000002','A','26.77','广东省');
INSERT INTO TABLE4 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)
    VALUES ('南玻B','200012','B','3.58','广东省');
 
SELECT * FROM TABLE4;

SELECT STOCK, SYMBOL FROM TABLE4;

SELECT * FROM TABLE4 WHERE PRICE>30 AND PRICE<100 ORDER BY PRICE DESC;
*/

CREATE TABLE TABLE6 (
    Stkcd char (200),
    Trddt char (255),
    Opnprc char (60),
    Clsprc char (100),
    Dnshrtrd char (100)
);
INSERT INTO TABLE6 VALUES ('603897', '2019/01/02', '23.01', '22.81', '2176373');
INSERT INTO TABLE6 VALUES ('603898', '2019/01/02', '15.33', '15.33', '852951');
INSERT INTO TABLE6 VALUES ('603899', '2019/01/02', '30.15', '28.86', '3435768');
INSERT INTO TABLE6 VALUES ('603900', '2019/01/02', '11.88', '11.82', '629531');
INSERT INTO TABLE6 VALUES ('603901', '2019/01/02', '6.59', '6.62', '968100');
INSERT INTO TABLE6 VALUES ('603903', '2019/01/02', '20.84', '20.15', '1865700');
INSERT INTO TABLE6 VALUES ('603906', '2019/01/02', '8.65', '8.63', '1106160');
INSERT INTO TABLE6 VALUES ('603908', '2019/01/02', '24.38', '24.51', '963600');
INSERT INTO TABLE6 VALUES ('603909', '2019/01/02', '25.52', '25.7', '1089096');
INSERT INTO TABLE6 VALUES ('603912', '2019/01/02', '13.32', '13.7', '4097856');

SELECT * FROM TABLE6;

SELECT Stkcd, Opnprc FROM TABLE6;

SELECT * FROM TABLE6 WHERE Clsprc>10 AND Clsprc<20 ORDER BY Clsprc DESC;

/*
CREATE TABLE TABLE3 (
    Bankcd char (200),
    Shortbnm char (255),
    Stkcd char (6),
    Typrep char (1),
    Cash char (100)
);

INSERT INTO TABLE3 VALUES ('000027', '南京银行', '601009', 'B', '105220607000');
INSERT INTO TABLE3 VALUES ('000027', '南京银行', '601009', 'C', '93065245000');
INSERT INTO TABLE3 VALUES ('000027', '南京银行', '601009', 'A', '106225841000');
INSERT INTO TABLE3 VALUES ('000084', '贵阳银行', '601997', 'D', '41210720000');

SELECT * FROM TABLE3;

INSERT INTO TABLE3 VALUES ('000021', '北京银行', '601169', 'B', '184491000000');
INSERT INTO TABLE3 VALUES ('000077', '杭州银行', '600927', 'D', '68901675000');

SELECT * FROM TABLE3;

UPDATE TABLE3 SET Stkcd=600926 WHERE Shortbnm='杭州银行';

DELETE FROM TABLE3 WHERE Typrep='D';
INSERT INTO TABLE3 VALUES ('000014', '招商银行', '600036', 'B','599416000000');

SELECT * FROM TABLE3;
*/