SQL语句——创建表，添加记录

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