CREATE DATABASE test;
use test;
CREATE TABLE TABLE4(
STOCK varchar(30),
SYMBOL char(6),
SHARETYPE char(1),
PRICE decimal(10,2),
PROVINCE varchar(20)
);
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