1.插入数据
格式:
INSERT INTO ***
VALUES();
#方式一:
#1.严格按照声明顺序添加数据
INSERT INTO emp1
VALUES(1,'TOM','2000-12-22',1400);
#2.指明要添加的字段(一一对应)
INSERT INTO emp1(id,hire_date,salary,`name`)
VALUES(2,'2016-04-29',3000,'hippo');
#3.同时插入多条数据
INSERT INTO emp1(id,`name`,hire_date,salary)
VALUES
(4,'河马','1998-12-22',400),
(5,'花花','1998-11-10',40000);
#方式二:将查询结果插入到表中
INSERT INTO emp1(id,`name`,salary,hire_date)
#查询语句
SELECT employee_id,last_name,salary,hire_date
FROM employees
WHERE department_id IN (60,70);
2.更新数据
格式:
UPDATE ***
SET ***
WHERE ***;
#1.
UPDATE emp1
SET hire_date = CURDATE()
WHERE id = 5;
#同时修改一条数据的多个字段
UPDATE emp1
SET hire_date = CURDATE(),salary = 6000
WHERE id = 3;
#姓名包含o的提高工资
UPDATE emp1
SET salary = salary * 1.2
WHERE name LIKE ('%o%');
3.删除数据
格式:
DELETE FROM ***
WHERE ***;
DELETE FROM emp1
WHERE id = 1;