數(shù)據(jù)庫(kù)操作語(yǔ)句
insert into liubo values(1,'小明',12);
insert into liubo(name,priovince,sge) values('名','山東',20);插入一個(gè)數(shù)據(jù)
insert into liubo(name,priovince,sge) values('名','山東',20)减拭,('名','山東',20)厢汹,('名','山東',20)琉用,('名','山東',20);插入多個(gè)數(shù)據(jù)威根,中間用逗號(hào)隔開(kāi)你辣;
用delete刪除數(shù)據(jù)店印,【注意】用where限制仑氛,不然表中數(shù)據(jù)全部沒(méi)有了械荷。
delete from bb where id =2;
update更新數(shù)據(jù)翠拣,【注意】也要住where限制
update liubo set money = 4000,age=30 where id = 1;