插入数据
insert into table_name (column_list) values(value_list)
插入一条记录
insert into person (id,name,age,info) values(1,'Green',21,'Lawyer');
列表名可以省略
例如:
insert into persion values(2,'Marry',24,'Musiacan');
可以插入指定列:
insert into person(name,age,info) values('Willam',20,'sports man');
同时插入多条记录
insert into persion(name,age,info) values('Evans',27,'secretary'),('Dale',22,'cok'),('Edision',28,'singer')