编辑代码

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-20', 69.97);
INSERT INTO TABLE1 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE) 
VALUES ('长安B', '200625', 'B', '2021-05-20', 7.11);
INSERT INTO TABLE1 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE) 
VALUES ('ST星源', '000005', 'A', '2021-05-20', 1.82);

select*from TABLE1;#让表格显示出来

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;
*/
CREATE TABLE TABLE2 (
    STOCK varchar(20),
    SYMBOL char(6),
    SHARETYPE char(1),
    PRICE decimal(10,2),
    PROVINCE varchar(20)
);

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) 
VALUES ('平安银行', '200012', 'B', 3.58, '广东省');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) 
VALUES ('长安B', '200625', 'B', 7.11, '重庆市');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) 
VALUES ('ST星源', '000005', 'A', 1.82, '广东省');