SQL–DML
- 数据操作语言DML(Data Manipulation Language)
- 常用语句: insert,delete,update
DML 数据操作语言
insert(插入数据),delete(删除数据),update(修改数据)
now() 获取数据库所在系统的当前时间
1.插入数据
方法1
INSERT INTO t_student (NAME,sex,mobile,height,regexp_time)
VALUES('张三','男','13333333333','175.2',NOW());
方法2
INSERT INTO t_student SET NAME
='李四',sex='女',phone='12222222222',height='165.0',regexp_time=NOW();
方法3
INSERT INTO t_student (NAME,sex,phone,height,regexp_time)
VALUES ('王五','男','14444444444','195.5',NOW()),('赵六','女','15555555555','155.2',NOW());
2.修改数据
UPDATE t_student SET phone = '18899996666' WHERE num = 1;
3.删除数据
DELETE FROM t_student WHERE num = 4;
-- 清空整张表
TRUNCATE TABLE t_teacher;