mysql DMl 增 改 删 基本语法

插入语句

关键词 insert into

1. insert into table_name(column1, column2, … ) values (value1, value2, …);
   eg:

   insert into beauty(id, name, sex, borndate, phone, photo, boyfriend_id) 
   values(13, '唐艺昕', '女', '1990-4-30','189888888',null, 2);
   

   注意：
   1. 列名 可以省略，默认全部
   2. 可以为null 的列名可以省略，如果省略值为null
   3. 列的顺序可以改变
   4. 支持插入多行
   5. 可以搭配子查询

2. insert into table_name set column1=value1, column2=value2,…;
   eg:
   insert into beauty set name='张西三', phone='112983838';

修改语句

关键词 update

1. update table_name set column1=value1, column2=value2,… where 条件;
   eg:
   update beauty set boyfriend_id=2 where id=14;

删除语句

关键词 delete

1. delete from table_name where 条件;
   eg:
   delete from beauty where id=1;

2. truncate from table_name
   eg:
   truncate from beauty;