insert into studentclass(name,age,email.tel,datetimes) values ('刘雪莹',20,'liuxueyin@qq.com','13800138000',1579011111);
不写列
如果不写列名,默认插入所有的列,但是需要把每个值进行赋值(主键不需要)
1
insert into studentclass values ('刘雪莹',20,'liuxueyin@qq.com','13800138000',1579011111);
一次性插入多个行
1
insert into studentclass values ('刘雪莹',20,'liuxueyin@qq.com','13800138000',1579011111),('刘雪莹',20,'liuxueyin@qq.com','13800138000',1579011111),('刘雪莹',20,'liuxueyin@qq.com','13800138000',1579011111);
表 的修改
1
update studentclass set name = '马超',tel = '138001380000' where id = 2;