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