CREATE DATABASE test;
use test;
create table TABLE4(
  	STOCK varchar(20),
	SYMBOL varchar(20),
	SHARETYPE varchar(10),
	PRICE float,
    PROVINCE VARCHAR(20)
);
insert into TABLE4 values('平安银行','000001','A',69.97,'广东省');
insert into TABLE4 values('长安B','200625','B',7.11,'重庆市');
insert into TABLE4 values('比亚迪','002594','A',172.78,'广东省');
insert into TABLE4 values('东信B','900941','B',0.47,'浙江省');
insert into TABLE4 values('复星医药','600196','A',65.00,'上海市');
insert into TABLE4 values('ST星源','000005','A',1.82,'广东省');
insert into TABLE4 values('北京城乡','600861','A',14.38,'北京市');
insert into TABLE4 values('三环集团','300408','A',37.41,'广东省');
insert into TABLE4 values('万科A','000002','A',26.77,'广东省');
insert into TABLE4 values('南坡B','200012','B',3.58,'广东省');

select * from TABLE4;