DML
Data Manipulation Language 对数据库的记录进行更新 增 删 改
插入
-
向表中插入某些列
insert into tableName(filedName1, filedName2, filedName3) values (value1, value2, value3); INSERT INTO stu (sid, name) VALUES (0, 'xiaoli');
-
向表插入所有列
insert into tableName values(value1, value2, value3...); INSERT INTO stu VALUES(3, 'xiaowang', 'man', 1, 'noll', '2021-10-10');
删除
-
delete
delete from tableName [where condition]; DELETE FROM stu WHERE sid = 0;
-
truncate
truncate table tableName/ truncate tableName;
删除旧表 建立新表
对约束不一样,对事务不一样
更新
-
修改所有
update tableName set filedName = value1, filedName = value2; UPDATE stu SET `name` = 'xiaoli';
-
修改某条
update tableName set filedName = value1, filedName = value2 where condition; UPDATE stu SET `name` = 'xiaolia' WHERE sid = 0;