编辑代码

CREATE DATABASE test;
use test;
/*
CREATE TABLE TABLE1
(
    STOCK varchar(20),
    SYMBOL char(6),
    SHARETYPE char(1),
    TRADEDATE date,
    PRICE decimal(10,2)
);
INSERT INTO TABLE1(STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE) VALUES ('平安银行', '000001', 'A', '2021-05-28', 69.97);
INSERT INTO TABLE1(STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE) VALUES ('长安汽车', '000625', 'B', '2021-05-20', 7.11);
INSERT INTO TABLE1(STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE) VALUES ('ST星源', '000005', 'A', '2021-05-20', 1.82);
INSERT INTO TABLE1(STOCK, SHARETYPE)VALUES('比亚迪', 'A');
ALTER TABLE TABLE1 ADD (PROVINCE varchar(10));
UPDATE TABLE1 SET PRICE=70.2 WHERE STOCK='平安银行';
UPDATE TABLE1 SET PRICE=70.15, SYMBOL='000002' WHERE STOCK='平安银行';
DELETE FROM TABLE1 WHERE STOCK='平安银行';
DELETE FROM TABLE1;
*/
CREATE TABLE TABLE2
(
    STOCK varchar(20),
    SYMBOL char(6),
    SHARETYPE char(1),
    PRICE decimal(10,2),
    PROVINCE char(20)
    );
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES ('ST星源', '000005', 'A', 1.82, '广东省');
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES ('北京城建', '600861', 'A', 14.38, '北京市');
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES ('三环集团', '300408', 'A', 37.41, '广东省');
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES ('万科A', '000002', 'A', 26.77, '广东省');
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES ('南玻A', '200012', 'B', 3.58, '广东省');
UPDATE TABLE2 SET PRICE=16.25 WHERE STOCK='平安银行';
DELETE FROM TABLE2 WHERE STOCK='B';
DELETE FROM TABLE2 WHERE STOCK='平安银行';
INSERT INTO TABLE2 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('平安银行','000001', 'A',16.25, '广东省');