SQL增删改查

1、添加语句

insert into 表 (要插入字段) values (数据)
​
案例:
INSERT INTO student (NAME,age,phone) VALUE ("张三",19,"190778866")
INSERT INTO student   (ID,NAME,age,phone) (5,"李四",19,"190778866");
INSERT INTO student   VALUE (NULL,"王五",19,"190778866");

• SQL语句实现批量

方法1：使用多条语句插入

方法2：使用SQL自带批量插入

INSERT INTO student (NAME,age,phone) VALUES ("张飞",33,"190778866"),("关羽",36,"190778866"),("刘备",38,"190778866")

2、修改语句

update 表 set 字段=值 where 条件

UPDATE student SET NAME="张翼德" WHERE NAME="张飞" 

3、删除语句

delete from 表 where 条件

DELETE FROM student WHERE NAME="张三"