CREATE TABLE stor_information
(store_name char(20),
sales int,
date datetime,
)
insert stor_information(store_name,sales,date)values('San Diego',250,'1999/01/07')
insert stor_information(store_name,sales,date)values('San Francisco',300,'1999/01/08')
insert stor_information(store_name,sales,date)values('Boston',700,'1999/01/08')
转载于:https://blog.51cto.com/zhaojing9023/1309986