编辑代码

CREATE DATABASE test;
use test;
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,'广东省');
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('南玻B',200012,'B',3.58,'广东省');
select *from TABLE2;

UPDATE TABLE2 SET PRICE=16.25 WHERE STOCK='平安银行';
select *from TABLE2;

DELETE FROM TABLE2 WHERE STOCK='长安B';
select *from TABLE2;

DELETE FROM TABLE2 WHERE STOCK='平安银行';
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('平安银行',000001,'A',16.25,'广东省');
select *from TABLE2;