mysql 增删改查操作笔记

• DELETE

  • 1、有 WHERE
    DELETE FROM table_name WHERE id=39;
  • 2、无 WHERE
    DELETE FROM table_name;
    或
    DELETE * FROM table_name;
  • 总结
    DELETE后面不加 " * " 不会错，有WHERE一定不要星号。

• UPDATE

  • 设置值为Null
    update table_name set b=null where id=2

• GROUP BY

• ORDER BY

• select 的内容要和group by的内容一致。

• select 的内容要和order by的内容无需一致。
  SELECT DISTINCT(id) from table_name where adate=‘2020-05-20’ ORDER BY id
  SELECT * from table_name where update_time=‘2021-07-02 08:43:50’ ORDER BY id 【查询正常】
  SELECT * from table_name where update_time=‘2021-07-02 08:43:50’ GROUP BY id 【error】