DML

DML

：数据操作语言

：常用语句insert、update 、delete

1、insert：插入数据

# 方式1: INSERT INTO 表名(列1,列2……,列n) VALUES(值1,值2…..,值n);

--       不指定列,默认给所有的列插入数据  
INSERT INTO t_student VALUES(100,"jim",'男','1999-10-10',99,'1522222222',NOW())

INSERT INTO t_student(stu_num,stu_name,stu_sex) VALUES(101,"jim",'男')

#方式2: INSERT INTO 表名 set 列名1=值1,..列名n=值n;

INSERT INTO t_student SET stu_num=102,stu_name='tom',stu_sex='女'

#方式3 INSERT INTO 表名(列1,列2……,列n) VALUES(值1,值2…..,值n),(值1,值2…..,值n);

INSERT INTO t_student(stu_num,stu_name,stu_sex) VALUES(103,"jim1",'男'),(104,"jim2",'男')

#方式4 方式4:INSERT INTO 表名(列1,列2……,列n) 查询语句(查询的列数与插入列数匹配)

INSERT INTO t_student(stu_num,stu_name,stu_sex) SELECT stu_num,stu_name,stu_sex FROM t_score WHERE stu_num=100

2、update：修改数据

 # 修改数据  update 表名 set 列名=值,列名=值  [where 条件]
UPDATE t_student SET  stu_sex="男",stu_address='汉中市 东一环路'

3、delete：删除数据

# 删除数据  delete from  表名 [where 条件]
DELETE FROM t_student WHERE stu_sex='男'
TRUNCATE  TABLE t_student -- 清空表中数据

-- drop table t_student 删除表结构,数据也会不存在