mysql -- 增、删、改

 

一、增

  INSERT into `表名` (列名1,列名2) VALUES (值1,值2);

新增一条记录  

INSERT into `user` (name, age, address) VALUES ('帅哥', 18, '漳州');

 

插入多行

INSERT into
    `user` (name, age, address)
VALUES ('zxd帅哥', 17, '泉州'),
    ('cyy美女', 17, '泉州');

 

如果表结构支持    可以插入空值

INSERT into `user` (name, age, address) VALUES (Null, NULL, Null);

 

二、改

UPDATE `表名` SET 列名1 = 值1,列名2 = 值2 WHERE id = 1;

UPDATE `user` SET name = 'zxd', age = 18, address = '漳州' WHERE id = 5;

 

三、删除

DELETE from `user` WHERE id = 5;

 

批量删除

DELETE from `user` WHERE id IN (7, 8);