MySQL常用语句(一)

最新推荐文章于 2024-06-22 21:31:42 发布

pjmike

最新推荐文章于 2024-06-22 21:31:42 发布

阅读量904

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/pjmike233/article/details/81478133

版权

本文详细介绍了MySQL中的常用查询语句，包括Show语句来查看系统变量、用户权限等信息，以及查询语句如DISTINCT、LIMIT、ORDER BY、WHERE子句等。还涵盖了排序、过滤、计算字段、数据处理函数、聚集函数以及分组数据的方法，是MySQL初学者的实用指南。

摘要由CSDN通过智能技术生成

关于Show语句

show语句可以用来查询数据库，表，列和服务器状态信息，show后面还可以跟like操作符，甚至有的还可以跟where语句

show variables 查看系统变量

show variables 显示MySQL系统变量的值

mysql> show variables like "%char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.07 sec)

show grants 查看用户权限

mysql> show grants;
+--------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@%                                                                                                              |
+--------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*DCC34AC0D1740AF22078E4130604D4AC65207D0E' WITH GRANT OPTION |
+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.07 sec)

show columns from TABLES 查看表的列信息

mysql> show columns from user;
+-------------+--------------+------+-----+-------------------+----------------+
| Field       | Type         | Null | Key | Default           | Extra          |
+-------------+--------------+------+-----+-------------------+----------------+
| id          | int(11)      | NO   | PRI | NULL              | auto_increment |
| phone       | varchar(255) | NO   |     | NULL              |                |
| username    | varchar(255) | NO   |     | NULL              |                |
| password    | varchar(255) | NO   |     | NULL              |                |
| avatar      | varchar(255) | YES  |     | NULL              |                |
| gender      | tinyint(11)  | YES  |     | NULL              |                |
| email       | varchar(255) | YES  |     | NULL              |                |
| salt        | var