Last active
May 10, 2019 02:45
-
-
Save wxingheng/6981097551aeb200302832163f79f521 to your computer and use it in GitHub Desktop.
mysql 基本语法
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| **修改mysql时区** | |
| [mysql 时区](https://www.cnblogs.com/shiqiangqiang/p/8393662.html) | |
| **修改mysql默认字符集** | |
|  | |
| **查询** | |
| SELECT * FROM user; | |
| **条件查询 core >= 80** | |
| SELECT * FROM user WHERE core >= 80; | |
| **多条件查询 core >= 80 并且 age=1** | |
| SELECT * FROM user WHERE core >= 80 AND age=1; | |
| **或条件查询 core >= 80 或者 age=1** | |
| SELECT * FROM user WHERE core >= 80 OR age=1; | |
| **不符合条件查询 core >= 80** | |
| SELECT * FROM user WHERE NOT core >= 80; | |
| **投影查询** | |
| SELECT User username, age FROM user ; | |
| **查询排序** | |
| 按照 core 从小分到大； | |
| SELECT * FROM user ORDER BY core; | |
| 按照 core 从大分到小； | |
| SELECT * FROM user ORDER BY core DESC; | |
| 按照 core 从大分到小, age 从小到大； | |
| SELECT * FROM user ORDER BY core DESC, age; | |
| **插入数据** | |
| INSERT INTO user (age, core) VALUES (2, '男'), (1, '女')； | |
| **更新数据** | |
| UPDATE user SET core=1, age='男' WHERE id=1; | |
| **删除数据** | |
| DELETE FROM user WHERE id=1; | |
| [Mysql](https://www.liaoxuefeng.com/wiki/001508284671805d39d23243d884b8b99f440bfae87b0f4000/0015091673702648348ebd1890f4c27a3787a93b740586b000) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment