编辑代码

CREATE DATABASE test;
use test;

create table TABLE1(
    stock varchar(20),
    symbol char(6),
    sharetype char(1),
    tradedate date,
    price decimal(10,2)
);