mysql 修改记录 能删除吗_Mysql 修改和删除记录操作

-- 测试更新语句

-- 修改第一个用户的信息 id=1

UPDATE tbl_name SET 字段名称=值,字段名称=值 [WHERE 条件]

UPDATE user SET age=29 WHERE id=1;

-- 修改id=3的用户，username age email

UPDATE user SET age=47,email='13465@qq.com',username='lilys' WHERE id=3;

-- 所有用户年龄+10

UPDATE user SET age=age+10;

-- 将id<=5的用户年龄改为-20，将邮箱改为默认值

UPDATE user SET age=age-20,email=DEFAULT WHERE id<=5;

-- 测试删除语句

DELETE FROM tbl_name [WHERE 条件]

-- 删除用户名为king

DELETE FROM user WHERE username='king';

-- 删除年龄为24的用户

DELETE FROM user WHERE age=24;

-- 删除表中所有记录

DELETE FROM user;

INSERT user VALUES(NULL,'queen',25,'132456n@qq.com');

INSERT user VALUES(DEFAULT,'lily',26,'123987@qq.com');

-- 重置id

DELETE 清空数据表的时候不会重置AUTO_INCREMENT的值，可以通过ALTER 语句将其重置为1

ALTER TABLE user AUTO_INCREMENT=1

彻底清空数据表

清除表中所有记录,会重置AUTO_INCREMENT的值

TRUNCATE [TABLE] tbl_name;