-- 更新数据 把link_id 为null 更改为2UPDATE customer set link_id = 2 WHERE link_id is NULL -- 把地址为上海的更改link_id 为2 UPDATE customer set link_id =2 WHERE address ='上海'-- 把年龄小于20 并且 link_id =1的增加10ageUPDATE customer set age = age + 10 WHERE age < 20 AND link_id = 1-- 删除 customer表中 link_id 为空的DELETE FROM customer WHERE link_id is NULL -- 删除最后两条数据DELETE FROM customer order by id DESC limit 2-- 插入一条记录insert into customer set cname='c8', age = 23, address = '上海', link_id = 3-- 插入多条记录INSERT INTO customer (cname , age , address, link_id) values ('c9',24,'浦东',3),('c10',25,'pussy',3),('c11',26,'江里',3)