MySQL 按条件查询 2022/09/05

🔥 查询语句 🔥 

SELECT column_name1,column_name2 FROM table_name

[WHERE where_condition]

[GROUP BY {col_name | expr | position}] , ... [WITH ROLLUP]]

[WHERE where_condition]

[ORDER BY {col_name | expr | postion} [ASC | DESC] , ... [WITH ROLLUP]]

[LIMIT {[offset,] row_count | row_count OFFSET offset}]

show databases; 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

 use mysql;

mysql> use mysql;
Database changed

show tables;

mysql> show tables;
+------------------------------------------------------+
| Tables_in_mysql                                      |
+------------------------------------------------------+
| columns_priv                                         |
| component                                            |
| db                                                   |
| default_roles                                        |
| engine_cost                                          |
| func                                                 |
| general_log                                          |
| global_grants                                        |
| gtid_executed                                        |
| help_category                                        |
| help_keyword                                         |
| help_relation                                        |
| help_topic                                           |
| innodb_index_stats                                   |
| innodb_table_stats                                   |
| password_history                                     |
| plugin                                               |
| procs_priv                                           |
| proxies_priv                                         |
| replication_asynchronous_connection_failover         |
| replication_asynchronous_connection_failover_managed |
| replication_group_configuration_version              |
| replication_group_member_actions                     |
| role_edges                                           |
| server_cost                                          |
| servers                                              |
| slave_master_info                                    |
| slave_relay_log_info                                 |
| slave_worker_info                                    |
| slow_log                                             |
| tables_priv                                          |
| time_zone                                            |
| time_zone_leap_second                                |
| time_zone_name                                       |
| time_zone_transition                                 |
| time_zone_transition_type                            |
| user                                                 |
+------------------------------------------------------+
37 rows in set (0.00 sec)

mysql> select * from help_keyword;
+-----------------+----------------------------------------+
| help_keyword_id | name                                   |
+-----------------+----------------------------------------+
|             108 | %                                      |
|             264 | &                                      |
|             422 | (JSON                                  |
|              86 | *                                      |
|              84 | +                                      |
|              85 | -                                      |
|             423 | ->                                     |
|             425 | ->>                                    |
|              87 | /                                      |
|              75 | :=                                     |
|              59 | <                                      |
|             266 | <<                                     |
|              58 | <=                                     |
|              56 | <=>                                    |
|              57 | <>                                     |
|              55 | =                                      |
|              61 | >                                      |
|              60 | >=                                     |
|             267 | >>                                     |
|              90 | ABS                                    |
|             879 | ACCOUNT                                |
|              91 | ACOS                                   |
|             659 | ACTION                                 |
|              49 | ADD                                    |
|             120 | ADDDATE                                |
|             121 | ADDTIME                                |
|             913 | ADMIN                                  |
|             270 | AES_DECRYPT                            |
|             271 | AES_ENCRYPT                            |
|             581 | AFTER                                  |
|             247 | AGAINST                                |
|             935 | AGGREGATE                              |
|             582 | ALGORITHM                              |
|             721 | ALL                                    |
|              50 | ALTER                                  |
|             583 | ANALYZE                                |
|              62 | AND                                    |
|             526 | ANY_VALUE                              |
|             660 | ARCHIVE                                |
|             254 | ARRAY                                  |
|             722 | AS                                     |
|             464 | ASC                                    |
|             185 | ASCII                                  |
|              92 | ASIN                                   |
|             774 | ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS |
|               6 | ASYMMETRIC_DECRYPT                     |
|               7 | ASYMMETRIC_DERIVE                      |
|               8 | ASYMMETRIC_ENCRYPT                     |
|               9 | ASYMMETRIC_SIGN                        |
|              10 | ASYMMETRIC_VERIFY                      |
|             643 | AT                                     |
|              93 | ATAN                                   |
|              94 | ATAN2                                  |
|             880 | ATTRIBUTE                              |
|             911 | AUTHENTICATION                         |
|             743 | AUTOCOMMIT                             |
|             584 | AUTOEXTEND_SIZE                        |
|             585 | AUTO_INCREMENT                         |
|             458 | AVG                                    |
|             586 | AVG_ROW_LENGTH                         |
|             755 | BACKUP                                 |
|             769 | BEFORE                                 |
|             744 | BEGIN                                  |
|             288 | BENCHMARK                              |
|              63 | BETWEEN                                |
|             186 | BIN                                    |
|             253 | BINARY                                 |
|             563 | BINLOG                                 |
|             527 | BIN_TO_UUID                            |
|             460 | BIT_AND                                |
|             269 | BIT_COUNT                              |
|             187 | BIT_LENGTH                             |
|             461 | BIT_OR                                 |
|             462 | BIT_XOR                                |
|              17 | BOOL                                   |
|              18 | BOOLEAN                                |
|             230 | BOTH                                   |
|             647 | BTREE                                  |
|             465 | BY                                     |
|              42 | BYTE                                   |
|             970 | CACHE                                  |
|             689 | CALL                                   |
|             497 | CAN_ACCESS_COLUMN                      |
|             498 | CAN_ACCESS_DATABASE                    |
|             499 | CAN_ACCESS_TABLE                       |
|             500 | CAN_ACCESS_USER                        |
|             501 | CAN_ACCESS_VIEW                        |
|             661 | CASCADE                                |
|              76 | CASE                                   |
|             255 | CAST                                   |
|             860 | CATALOG_NAME                           |
|              95 | CEIL                                   |
|              96 | CEILING                                |
|             745 | CHAIN                                  |
|             881 | CHALLENGE_RESPONSE                     |
|             587 | CHANGE                                 |
|             564 | CHANNEL                                |
|              43 | CHAR                                   |
|              39 | CHARACTER                              |
|             189 | CHARACTER_LENGTH                       |
|             289 | CHARSET                                |
|             188 | CHAR_LENGTH                            |
|             588 | CHECK                                  |
|             589 | CHECKSUM                               |
|             882 | CIPHER                                 |
|             861 | CLASS_ORIGIN                           |
|             914 | CLIENT                                 |
|             943 | CLONE                                  |
|             695 | CLOSE                                  |
|              65 | COALESCE                               |
|             964 | CODE                                   |
|             290 | COERCIBILITY                           |
|             546 | COLLATE                                |
|             291 | COLLATION                              |
|             590 | COLUMN                                 |
|             591 | COLUMNS                                |
|             862 | COLUMN_NAME                            |
|             551 | COMMENT                                |
|             746 | COMMIT                                 |
|             758 | COMMITTED                              |
|             662 | COMPACT                                |
|             552 | COMPLETION                             |
|             939 | COMPONENT                              |
|             272 | COMPRESS                               |
|             663 | COMPRESSED                             |
|             592 | COMPRESSION                            |
|             190 | CONCAT                                 |
|             191 | CONCAT_WS                              |
|             708 | CONCURRENT                             |
|             857 | CONDITION                              |
|             593 | CONNECTION                             |
|             292 | CONNECTION_ID                          |
|             747 | CONSISTENT                             |
|             594 | CONSTRAINT                             |
|             863 | CONSTRAINT_CATALOG                     |
|             864 | CONSTRAINT_NAME                        |
|             865 | CONSTRAINT_SCHEMA                      |
|             858 | CONTINUE                               |
|              97 | CONV                                   |
|             260 | CONVERT                                |
|             122 | CONVERT_TZ                             |
|              98 | COS                                    |
|              99 | COT                                    |
|             463 | COUNT                                  |
|             100 | CRC32                                  |
|              51 | CREATE                                 |
|              11 | CREATE_ASYMMETRIC_PRIV_KEY             |
|              12 | CREATE_ASYMMETRIC_PUB_KEY              |
|              13 | CREATE_DH_PARAMETERS                   |
|              14 | CREATE_DIGEST                          |
|             738 | CROSS                                  |
|             664 | CSV                                    |
|             482 | CUME_DIST                              |
|             123 | CURDATE                                |
|             883 | CURRENT                                |
|             124 | CURRENT_DATE                           |
|             293 | CURRENT_ROLE                           |
|             125 | CURRENT_TIME                           |
|             126 | CURRENT_TIMESTAMP                      |
|             294 | CURRENT_USER                           |
|             855 | CURSOR                                 |
|             866 | CURSOR_NAME                            |
|             127 | CURTIME                                |
|             595 | DATA                                   |
|             295 | DATABASE                               |
|             948 | DATABASES                              |
|             636 | DATAFILE                               |
|              36 | DATE                                   |
|             128 | DATEDIFF                               |
|             256 | DATETIME                               |
|             129 | DATE_ADD                               |
|             144 | DATE_FORMAT                            |
|             130 | DATE_SUB                               |
|             131 | DAY                                    |
|             145 | DAYNAME                                |
|             146 | DAYOFMONTH                             |
|             147 | DAYOFWEEK                              |
|             148 | DAYOFYEAR                              |
|             132 | DAY_HOUR                               |
|             133 | DAY_MINUTE                             |
|             134 | DAY_SECOND                             |
|             846 | DEALLOCATE                             |
|              28 | DEC                                    |
|              31 | DECIMAL                                |
|             847 | DECLARE                                |
|               2 | DEFAULT                                |
|             837 | DEFAULT_AUTH                           |
|             553 | DEFINER                                |
|             653 | DEFINITION                             |
|             101 | DEGREES                                |
|             701 | DELAYED                                |
|             596 | DELAY_KEY_WRITE                        |
|             665 | DELETE                                 |
|             483 | DENSE_RANK                             |
|             466 | DESC                                   |
|             981 | DESCRIBE                               |
|             654 | DESCRIPTION                            |
|             867 | DIAGNOSTICS                            |
|             597 | DIRECTORY                              |
|             554 | DISABLE                                |
|             598 | DISCARD                                |
|             459 | DISTINCT                               |
|             723 | DISTINCTROW                            |
|              88 | DIV                                    |
|             555 | DO                                     |
|             599 | DROP                                   |
|             737 | DUAL                                   |
|             724 | DUMPFILE                               |
|             702 | DUPLICATE                              |
|             666 | DYNAMIC                                |
|              77 | ELSE                                   |
|             848 | ELSEIF                                 |
|             192 | ELT                                    |
|             556 | ENABLE                                 |
|             709 | ENCLOSED                               |
|             547 | ENCRYPTION                             |
|              78 | END                                    |
|             644 | ENDS                                   |
|             600 | ENGINE                                 |
|             949 | ENGINES                                |
|             565 | ERROR                                  |
|             950 | ERRORS                                 |
|             239 | ESCAPE                                 |
|             710 | ESCAPED                                |
|             557 | EVENT                                  |
|             962 | EVENTS                                 |
|             645 | EVERY                                  |
|             926 | EXCEPT                                 |
|             601 | EXCHANGE                               |
|             845 | EXECUTE                                |
|             642 | EXISTS                                 |
|             859 | EXIT                                   |
|             102 | EXP                                    |
|             248 | EXPANSION                              |
|             884 | EXPIRE                                 |
|             982 | EXPLAIN                                |
|             971 | EXPORT                                 |
|             193 | EXPORT_SET                             |
|             933 | EXTENDED                               |
|             682 | EXTENT_SIZE                            |
|             149 | EXTRACT                                |
|             424 | EXTRACTION)                            |
|             261 | EXTRACTVALUE                           |
|             885 | FACTOR                                 |
|             886 | FAILED_LOGIN_ATTEMPTS                  |
|              15 | FALSE                                  |
|             931 | FAST                                   |
|             667 | FEDERATED                              |
|             856 | FETCH                                  |
|             194 | FIELD                                  |
|             711 | FIELDS                                 |
|             915 | FILE                                   |
|             683 | FILE_BLOCK_SIZE                        |
|             803 | FILTER                                 |
|             195 | FIND_IN_SET                            |
|             887 | FINISH                                 |
|             602 | FIRST                                  |
|             484 | FIRST_VALUE                            |
|              29 | FIXED                                  |
|              32 | FLOAT4                                 |
|              33 | FLOAT8                                 |
|             103 | FLOOR                                  |
|             972 | FLUSH                                  |
|             566 | FOR                                    |
|             739 | FORCE                                  |
|             603 | FOREIGN                                |
|             196 | FORMAT                                 |
|             493 | FORMAT_BYTES                           |
|             494 | FORMAT_PICO_TIME                       |
|             296 | FOUND_ROWS                             |
|             231 | FROM                                   |
|             197 | FROM_BASE64                            |
|             150 | FROM_DAYS                              |
|             151 | FROM_UNIXTIME                          |
|             668 | FULL                                   |
|             604 | FULLTEXT                               |
|             169 | FUNCTION                               |
|             973 | GENERAL                                |
|             336 | GEOMCOLLECTION                         |
|             337 | GEOMETRYCOLLECTION                     |
|             868 | GET                                    |
|             502 | GET_DD_COLUMN_PRIVILEGES               |
|             503 | GET_DD_CREATE_OPTIONS                  |
|             504 | GET_DD_INDEX_SUB_PART_LENGTH           |
|             152 | GET_FORMAT                             |
|             283 | GET_LOCK                               |
|             759 | GLOBAL                                 |
|             916 | GRANT                                  |
|             951 | GRANTS                                 |
|              66 | GREATEST                               |
|             576 | GROUP                                  |
|             528 | GROUPING                               |
|             467 | GROUP_CONCAT                           |
|             454 | GTID_SUBSET                            |
|             455 | GTID_SUBTRACT                          |
|             696 | HANDLER                                |
|             725 | HAVING                                 |
|             669 | HEAP                                   |
|               5 | HELP                                   |
|               0 | HELP_DATE                              |
|               1 | HELP_VERSION                           |
|             198 | HEX                                    |
|             703 | HIGH_PRIORITY                          |
|             888 | HISTORY                                |
|             648 | HOST                                   |
|             952 | HOSTS                                  |
|             135 | HOUR                                   |
|             136 | HOUR_MINUTE                            |
|             137 | HOUR_SECOND                            |
|             297 | ICU_VERSION                            |
|             719 | IDENTIFIED                             |
|              81 | IF                                     |
|              82 | IFNULL                                 |
|             704 | IGNORE                                 |
|             775 | IGNORE_SERVER_IDS                      |
|             605 | IMPORT                                 |
|              67 | IN                                     |
|              52 | INDEX                                  |
|             953 | INDEXES                                |
|             531 | INET6_ATON                             |
|             532 | INET6_NTOA                             |
|             529 | INET_ATON                              |
|             530 | INET_NTOA                              |
|             712 | INFILE                                 |
|             912 | INITIAL                                |
|             637 | INITIAL_SIZE                           |
|             889 | INITIATE                               |
|             426 | INLINE                                 |
|             740 | INNER                                  |
|             567 | INNODB                                 |
|             199 | INSERT                                 |
|             606 | INSERT_METHOD                          |
|             940 | INSTALL                                |
|             568 | INSTANCE                               |
|             200 | INSTR                                  |
|              19 | INT1                                   |
|              22 | INT2                                   |
|              23 | INT3                                   |
|              25 | INT4                                   |
|              27 | INT8                                   |
|              26 | INTEGER                                |
|             505 | INTERNAL_AUTO_INCREMENT                |
|             506 | INTERNAL_AVG_ROW_LENGTH                |
|             508 | INTERNAL_CHECKSUM                      |
|             507 | INTERNAL_CHECK_TIME                    |
|             509 | INTERNAL_DATA_FREE                     |
|             510 | INTERNAL_DATA_LENGTH                   |
|             511 | INTERNAL_DD_CHAR_LENGTH                |
|             512 | INTERNAL_GET_COMMENT_OR_ERROR          |
|             513 | INTERNAL_GET_ENABLED_ROLE_JSON         |
|             514 | INTERNAL_GET_HOSTNAME                  |
|             515 | INTERNAL_GET_USERNAME                  |
|             516 | INTERNAL_GET_VIEW_WARNING_OR_ERROR     |
|             517 | INTERNAL_INDEX_COLUMN_CARDINALITY      |
|             518 | INTERNAL_INDEX_LENGTH                  |
|             519 | INTERNAL_IS_ENABLED_ROLE               |
|             520 | INTERNAL_IS_MANDATORY_ROLE             |
|             521 | INTERNAL_KEYS_DISABLED                 |
|             522 | INTERNAL_MAX_DATA_LENGTH               |
|             523 | INTERNAL_TABLE_ROWS                    |
|             524 | INTERNAL_UPDATE_TIME                   |
|              68 | INTERVAL                               |
|             705 | INTO                                   |
|             607 | INVISIBLE                              |
|             838 | IO_THREAD                              |
|              69 | IS                                     |
|              71 | ISNULL                                 |
|             760 | ISOLATION                              |
|             890 | ISSUER                                 |
|             284 | IS_FREE_LOCK                           |
|             533 | IS_IPV4                                |
|             534 | IS_IPV4_COMPAT                         |
|             535 | IS_IPV4_MAPPED                         |
|             536 | IS_IPV6                                |
|             285 | IS_USED_LOCK                           |
|             537 | IS_UUID                                |
|             525 | IS_VISIBLE_DD_OBJECT                   |
|             849 | ITERATE                                |
|             726 | JOIN                                   |
|             257 | JSON                                   |
|             416 | JSON_ARRAY                             |
|             470 | JSON_ARRAYAGG                          |
|             434 | JSON_ARRAY_APPEND                      |
|             435 | JSON_ARRAY_INSERT                      |
|             419 | JSON_CONTAINS                          |
|             420 | JSON_CONTAINS_PATH                     |
|             444 | JSON_DEPTH                             |
|             421 | JSON_EXTRACT                           |
|             436 | JSON_INSERT                            |
|             428 | JSON_KEYS                              |
|             445 | JSON_LENGTH                            |
|             437 | JSON_MERGE                             |
|             438 | JSON_MERGE_PATCH                       |
|             439 | JSON_MERGE_PRESERVE                    |
|             417 | JSON_OBJECT                            |
|             471 | JSON_OBJECTAGG                         |
|             429 | JSON_OVERLAPS                          |
|             451 | JSON_PRETTY                            |
|             418 | JSON_QUOTE                             |
|             440 | JSON_REMOVE                            |
|             441 | JSON_REPLACE                           |
|             449 | JSON_SCHEMA_VALID                      |
|             450 | JSON_SCHEMA_VALIDATION_REPORT          |
|             430 | JSON_SEARCH                            |
|             442 | JSON_SET                               |
|             452 | JSON_STORAGE_FREE                      |
|             453 | JSON_STORAGE_SIZE                      |
|             448 | JSON_TABLE                             |
|             446 | JSON_TYPE                              |
|             443 | JSON_UNQUOTE                           |
|             447 | JSON_VALID                             |
|             431 | JSON_VALUE                             |
|              53 | KEY                                    |
|             569 | KEYRING                                |
|             608 | KEYS                                   |
|             609 | KEY_BLOCK_SIZE                         |
|             978 | KILL                                   |
|             485 | LAG                                    |
|             697 | LAST                                   |
|             153 | LAST_DAY                               |
|             298 | LAST_INSERT_ID                         |
|             486 | LAST_VALUE                             |
|             201 | LCASE                                  |
|             487 | LEAD                                   |
|             232 | LEADING                                |
|              72 | LEAST                                  |
|             850 | LEAVE                                  |
|             979 | LEAVES                                 |
|             202 | LEFT                                   |
|             203 | LENGTH                                 |
|             761 | LEVEL                                  |
|             223 | LIKE                                   |
|             690 | LIMIT                                  |
|             713 | LINES                                  |
|             338 | LINESTRING                             |
|             104 | LN                                     |
|             714 | LOAD                                   |
|             204 | LOAD_FILE                              |
|             715 | LOCAL                                  |
|             154 | LOCALTIME                              |
|             155 | LOCALTIMESTAMP                         |
|             205 | LOCATE                                 |
|             610 | LOCK                                   |
|             105 | LOG                                    |
|             107 | LOG10                                  |
|             106 | LOG2                                   |
|             577 | LOGFILE                                |
|             770 | LOGS                                   |
|              47 | LONG                                   |
|              48 | LONGBINARY                             |
|             851 | LOOP                                   |
|             206 | LOWER                                  |
|             691 | LOW_PRIORITY                           |
|             207 | LPAD                                   |
|             208 | LTRIM                                  |
|             156 | MAKEDATE                               |
|             157 | MAKETIME                               |
|             209 | MAKE_SET                               |
|             570 | MASTER                                 |
|             776 | MASTER_AUTO_POSITION                   |
|             777 | MASTER_BIND                            |
|             778 | MASTER_COMPRESSION_ALGORITHMS          |
|             779 | MASTER_CONNECT_RETRY                   |
|             780 | MASTER_HEARTBEAT_PERIOD                |
|             781 | MASTER_HOST                            |
|             782 | MASTER_LOG_FILE                        |
|             783 | MASTER_LOG_POS                         |
|             784 | MASTER_PASSWORD                        |
|             785 | MASTER_PORT                            |
|             538 | MASTER_POS_WAIT                        |
|             786 | MASTER_RETRY_COUNT                     |
|             787 | MASTER_SSL                             |
|             788 | MASTER_SSL_CA                          |
|             789 | MASTER_SSL_CERT                        |
|             790 | MASTER_SSL_CIPHER                      |
|             791 | MASTER_SSL_CRL                         |
|             792 | MASTER_SSL_CRLPATH                     |
|             793 | MASTER_SSL_KEY                         |
|             794 | MASTER_SSL_VERIFY_SERVER_CERT          |
|             795 | MASTER_TLS_CIPHERSUITES                |
|             796 | MASTER_TLS_VERSION                     |
|             797 | MASTER_USER                            |
|             798 | MASTER_ZSTD_COMPRESSION_LEVEL          |
|             249 | MATCH                                  |
|             472 | MAX                                    |
|             891 | MAX_CONNECTIONS_PER_HOUR               |
|             892 | MAX_QUERIES_PER_HOUR                   |
|             611 | MAX_ROWS                               |
|             684 | MAX_SIZE                               |
|             893 | MAX_UPDATES_PER_HOUR                   |
|             894 | MAX_USER_CONNECTIONS                   |
|             395 | MBRCONTAINS                            |
|             396 | MBRCOVEREDBY                           |
|             397 | MBRCOVERS                              |
|             398 | MBRDISJOINT                            |
|             399 | MBREQUALS                              |
|             400 | MBRINTERSECTS                          |
|             401 | MBROVERLAPS                            |
|             402 | MBRTOUCHES                             |
|             403 | MBRWITHIN                              |
|             273 | MD5                                    |
|             932 | MEDIUM                                 |
|             432 | MEMBER                                 |
|             727 | MEMORY                                 |
|             670 | MERGE                                  |
|             869 | MESSAGE_TEXT                           |
|             158 | MICROSECOND                            |
|             210 | MID                                    |
|              24 | MIDDLEINT                              |
|             473 | MIN                                    |
|             138 | MINUTE                                 |
|             139 | MINUTE_SECOND                          |
|             612 | MIN_ROWS                               |
|              89 | MOD                                    |
|             250 | MODE                                   |
|             613 | MODIFY                                 |
|             140 | MONTH                                  |
|             159 | MONTHNAME                              |
|             671 | MRG_MYISAM                             |
|             339 | MULTILINESTRING                        |
|             340 | MULTIPOINT                             |
|             341 | MULTIPOLYGON                           |
|             954 | MUTEX                                  |
|             672 | MYISAM                                 |
|             870 | MYSQL_ERRNO                            |
|             655 | NAME                                   |
|             947 | NAMES                                  |
|             539 | NAME_CONST                             |
|              40 | NATIONAL                               |
|             741 | NATURAL                                |
|              41 | NCHAR                                  |
|             673 | NDB                                    |
|             674 | NDBCLUSTER                             |
|             799 | NETWORK_NAMESPACE                      |
|             895 | NEVER                                  |
|             698 | NEXT                                   |
|             571 | NO                                     |
|             685 | NODEGROUP                              |
|             896 | NONE                                   |
|              64 | NOT                                    |
|             160 | NOW                                    |
|             930 | NO_WRITE_TO_BINLOG                     |
|             488 | NTH_VALUE                              |
|             489 | NTILE                                  |
|              70 | NULL                                   |
|              83 | NULLIF                                 |
|             871 | NUMBER                                 |
|              30 | NUMERIC                                |
|              44 | NVARCHAR                               |
|             211 | OCT                                    |
|             212 | OCTET_LENGTH                           |
|             433 | OF                                     |
|             728 | OFFSET                                 |
|             897 | OLD                                    |
|             558 | ON                                     |
|             548 | ONLY                                   |
|             699 | OPEN                                   |
|             614 | OPTIMIZE                               |
|             974 | OPTIMIZER_COSTS                        |
|             917 | OPTION                                 |
|             898 | OPTIONAL                               |
|             716 | OPTIONALLY                             |
|             579 | OPTIONS                                |
|              73 | OR                                     |
|             213 | ORD                                    |
|             468 | ORDER                                  |
|             656 | ORGANIZATION                           |
|             742 | OUTER                                  |
|             729 | OUTFILE                                |
|             649 | OWNER                                  |
|             615 | PACK_KEYS                              |
|             616 | PARSER                                 |
|             675 | PARTIAL                                |
|             617 | PARTITION                              |
|             618 | PARTITIONING                           |
|             619 | PASSWORD                               |
|             899 | PASSWORD_LOCK_TIME                     |
|             427 | PATH)                                  |
|             490 | PERCENT_RANK                           |
|             161 | PERIOD_ADD                             |
|             162 | PERIOD_DIFF                            |
|             944 | PERSIST                                |
|             945 | PERSIST_ONLY                           |
|             109 | PI                                     |
|             941 | PLUGIN                                 |
|             965 | PLUGINS                                |
|             839 | PLUGIN_DIR                             |
|             342 | POINT                                  |
|             343 | POLYGON                                |
|             650 | PORT                                   |
|             214 | POSITION                               |
|             110 | POW                                    |
|             111 | POWER                                  |
|              34 | PRECISION                              |
|             766 | PREPARE                                |
|             559 | PRESERVE                               |
|             700 | PREV                                   |
|             620 | PRIMARY                                |
|             918 | PRIVILEGES                             |
|             800 | PRIVILEGE_CHECKS_USER                  |
|             578 | PROCEDURE                              |
|             919 | PROCESS                                |
|             955 | PROCESSLIST                            |
|             966 | PROFILE                                |
|             967 | PROFILES                               |
|             923 | PROXY                                  |
|             495 | PS_CURRENT_THREAD_ID                   |
|             496 | PS_THREAD_ID                           |
|             771 | PURGE                                  |
|             163 | QUARTER                                |
|             251 | QUERY                                  |
|             692 | QUICK                                  |
|             215 | QUOTE                                  |
|             112 | RADIANS                                |
|             113 | RAND                                   |
|             900 | RANDOM                                 |
|             274 | RANDOM_BYTES                           |
|             491 | RANK                                   |
|             549 | READ                                   |
|              35 | REAL                                   |
|             621 | REBUILD                                |
|             767 | RECOVER                                |
|             572 | REDO_LOG                               |
|             676 | REDUNDANT                              |
|             657 | REFERENCE                              |
|             677 | REFERENCES                             |
|             241 | REGEXP                                 |
|             243 | REGEXP_INSTR                           |
|             244 | REGEXP_LIKE                            |
|             245 | REGEXP_REPLACE                         |
|             246 | REGEXP_SUBSTR                          |
|             901 | REGISTRATION                           |
|             975 | RELAY                                  |
|             968 | RELAYLOG                               |
|             801 | RELAY_LOG_FILE                         |
|             802 | RELAY_LOG_POS                          |
|             748 | RELEASE                                |
|             286 | RELEASE_ALL_LOCKS                      |
|             287 | RELEASE_LOCK                           |
|             573 | RELOAD                                 |
|             622 | REMOVE                                 |
|             560 | RENAME                                 |
|             623 | REORGANIZE                             |
|             624 | REPAIR                                 |
|             216 | REPEAT                                 |
|             762 | REPEATABLE                             |
|             217 | REPLACE                                |
|             836 | REPLICA                                |
|             969 | REPLICAS                               |
|             804 | REPLICATE_DO_DB                        |
|             805 | REPLICATE_DO_TABLE                     |
|             806 | REPLICATE_IGNORE_DB                    |
|             807 | REPLICATE_IGNORE_TABLE                 |
|             808 | REPLICATE_REWRITE_DB                   |
|             809 | REPLICATE_WILD_DO_TABLE                |
|             810 | REPLICATE_WILD_IGNORE_TABLE            |
|             811 | REPLICATION                            |
|             902 | REQUIRE                                |
|             772 | RESET                                  |
|             876 | RESIGNAL                               |
|             927 | RESOURCE                               |
|             980 | RESTART                                |
|             680 | RESTRICT                               |
|             903 | RETAIN                                 |
|             853 | RETURN                                 |
|             872 | RETURNED_SQLSTATE                      |
|             936 | RETURNS                                |
|             904 | REUSE                                  |
|             218 | REVERSE                                |
|             924 | REVOKE                                 |
|             219 | RIGHT                                  |
|             242 | RLIKE                                  |
|             905 | ROLE                                   |
|             299 | ROLES_GRAPHML                          |
|             574 | ROLLBACK                               |
|             114 | ROUND                                  |
|             706 | ROW                                    |
|             720 | ROWS                                   |
|             300 | ROW_COUNT                              |
|             625 | ROW_FORMAT                             |
|             492 | ROW_NUMBER                             |
|             220 | RPAD                                   |
|             221 | RTRIM                                  |
|             754 | SAVEPOINT                              |
|             561 | SCHEDULE                               |
|             301 | SCHEMA                                 |
|             956 | SCHEMAS                                |
|             873 | SCHEMA_NAME                            |
|             141 | SECOND                                 |
|             164 | SEC_TO_TIME                            |
|             707 | SELECT                                 |
|             469 | SEPARATOR                              |
|               3 | SERIAL                                 |
|             763 | SERIALIZABLE                           |
|             580 | SERVER                                 |
|             764 | SESSION                                |
|             302 | SESSION_USER                           |
|             550 | SET                                    |
|             275 | SHA                                    |
|             276 | SHA1                                   |
|             277 | SHA2                                   |
|             730 | SHARE                                  |
|             957 | SHOW                                   |
|             920 | SHUTDOWN                               |
|             115 | SIGN                                   |
|             878 | SIGNAL                                 |
|             258 | SIGNED                                 |
|             116 | SIN                                    |
|             562 | SLAVE                                  |
|             540 | SLEEP                                  |
|             976 | SLOW                                   |
|             749 | SNAPSHOT                               |
|             651 | SOCKET                                 |
|             937 | SONAME                                 |
|             222 | SOUNDEX                                |
|             224 | SOUNDS                                 |
|             812 | SOURCE                                 |
|             813 | SOURCE_AUTO_POSITION                   |
|             814 | SOURCE_BIND                            |
|             815 | SOURCE_COMPRESSION_ALGORITHMS          |
|             816 | SOURCE_CONNECT_RETRY                   |
|             817 | SOURCE_HEARTBEAT_PERIOD                |
|             818 | SOURCE_HOST                            |
|             819 | SOURCE_LOG_FILE                        |
|             820 | SOURCE_LOG_POS                         |
|             821 | SOURCE_PASSWORD                        |
|             822 | SOURCE_PORT                            |
|             541 | SOURCE_POS_WAIT                        |
|             823 | SOURCE_RETRY_COUNT                     |
|             824 | SOURCE_SSL                             |
|             825 | SOURCE_SSL_CA                          |
|             826 | SOURCE_SSL_CERT                        |
|             827 | SOURCE_SSL_CIPHER                      |
|             828 | SOURCE_SSL_CRL                         |
|             829 | SOURCE_SSL_CRLPATH                     |
|             830 | SOURCE_SSL_KEY                         |
|             831 | SOURCE_SSL_VERIFY_SERVER_CERT          |
|             832 | SOURCE_TLS_CIPHERSUITES                |
|             833 | SOURCE_TLS_VERSION                     |
|             834 | SOURCE_USER                            |
|             835 | SOURCE_ZSTD_COMPRESSION_LEVEL          |
|             225 | SPACE                                  |
|             626 | SPATIAL                                |
|             877 | SQLSTATE                               |
|             840 | SQL_AFTER_GTIDS                        |
|             841 | SQL_AFTER_MTS_GAPS                     |
|             842 | SQL_BEFORE_GTIDS                       |
|             731 | SQL_BIG_RESULT                         |
|             732 | SQL_BUFFER_RESULT                      |
|             733 | SQL_CALC_FOUND_ROWS                    |
|             773 | SQL_LOG_BIN                            |
|             734 | SQL_NO_CACHE                           |
|             735 | SQL_SMALL_RESULT                       |
|             843 | SQL_THREAD                             |
|             117 | SQRT                                   |
|             906 | SSL                                    |
|             750 | START                                  |
|             717 | STARTING                               |
|             646 | STARTS                                 |
|             278 | STATEMENT_DIGEST                       |
|             279 | STATEMENT_DIGEST_TEXT                  |
|             627 | STATS_AUTO_RECALC                      |
|             628 | STATS_PERSISTENT                       |
|             629 | STATS_SAMPLE_PAGES                     |
|             958 | STATUS                                 |
|             474 | STD                                    |
|             475 | STDDEV                                 |
|             476 | STDDEV_POP                             |
|             477 | STDDEV_SAMP                            |
|             844 | STOP                                   |
|             963 | STORAGE                                |
|             678 | STORED                                 |
|             736 | STRAIGHT_JOIN                          |
|             240 | STRCMP                                 |
|             938 | STRING                                 |
|             165 | STR_TO_DATE                            |
|             365 | ST_AREA                                |
|             344 | ST_ASBINARY                            |
|             408 | ST_ASGEOJSON                           |
|             346 | ST_ASTEXT                              |
|             345 | ST_ASWKB                               |
|             347 | ST_ASWKT                               |
|             373 | ST_BUFFER                              |
|             374 | ST_BUFFER_STRATEGY                     |
|             366 | ST_CENTROID                            |
|             410 | ST_COLLECT                             |
|             384 | ST_CONTAINS                            |
|             375 | ST_CONVEXHULL                          |
|             385 | ST_CROSSES                             |
|             376 | ST_DIFFERENCE                          |
|             349 | ST_DIMENSION                           |
|             386 | ST_DISJOINT                            |
|             387 | ST_DISTANCE                            |
|             411 | ST_DISTANCE_SPHERE                     |
|             359 | ST_ENDPOINT                            |
|             350 | ST_ENVELOPE                            |
|             388 | ST_EQUALS                              |
|             367 | ST_EXTERIORRING                        |
|             389 | ST_FRECHETDISTANCE                     |
|             404 | ST_GEOHASH                             |
|             306 | ST_GEOMCOLLFROMTEXT                    |
|             321 | ST_GEOMCOLLFROMWKB                     |
|             307 | ST_GEOMETRYCOLLECTIONFROMTEXT          |
|             322 | ST_GEOMETRYCOLLECTIONFROMWKB           |
|             308 | ST_GEOMETRYFROMTEXT                    |
|             323 | ST_GEOMETRYFROMWKB                     |
|             371 | ST_GEOMETRYN                           |
|             351 | ST_GEOMETRYTYPE                        |
|             409 | ST_GEOMFROMGEOJSON                     |
|             309 | ST_GEOMFROMTEXT                        |
|             324 | ST_GEOMFROMWKB                         |
|             390 | ST_HAUSDORFFDISTANCE                   |
|             368 | ST_INTERIORRINGN                       |
|             377 | ST_INTERSECTION                        |
|             391 | ST_INTERSECTS                          |
|             360 | ST_ISCLOSED                            |
|             352 | ST_ISEMPTY                             |
|             353 | ST_ISSIMPLE                            |
|             412 | ST_ISVALID                             |
|             405 | ST_LATFROMGEOHASH                      |
|             355 | ST_LATITUDE                            |
|             361 | ST_LENGTH                              |
|             310 | ST_LINEFROMTEXT                        |
|             325 | ST_LINEFROMWKB                         |
|             378 | ST_LINEINTERPOLATEPOINT                |
|             379 | ST_LINEINTERPOLATEPOINTS               |
|             311 | ST_LINESTRINGFROMTEXT                  |
|             326 | ST_LINESTRINGFROMWKB                   |
|             406 | ST_LONGFROMGEOHASH                     |
|             356 | ST_LONGITUDE                           |
|             413 | ST_MAKEENVELOPE                        |
|             312 | ST_MLINEFROMTEXT                       |
|             327 | ST_MLINEFROMWKB                        |
|             314 | ST_MPOINTFROMTEXT                      |
|             329 | ST_MPOINTFROMWKB                       |
|             316 | ST_MPOLYFROMTEXT                       |
|             331 | ST_MPOLYFROMWKB                        |
|             313 | ST_MULTILINESTRINGFROMTEXT             |
|             328 | ST_MULTILINESTRINGFROMWKB              |
|             315 | ST_MULTIPOINTFROMTEXT                  |
|             330 | ST_MULTIPOINTFROMWKB                   |
|             317 | ST_MULTIPOLYGONFROMTEXT                |
|             332 | ST_MULTIPOLYGONFROMWKB                 |
|             372 | ST_NUMGEOMETRIES                       |
|             369 | ST_NUMINTERIORRING                     |
|             370 | ST_NUMINTERIORRINGS                    |
|             362 | ST_NUMPOINTS                           |
|             392 | ST_OVERLAPS                            |
|             380 | ST_POINTATDISTANCE                     |
|             407 | ST_POINTFROMGEOHASH                    |
|             318 | ST_POINTFROMTEXT                       |
|             333 | ST_POINTFROMWKB                        |
|             363 | ST_POINTN                              |
|             319 | ST_POLYFROMTEXT                        |
|             334 | ST_POLYFROMWKB                         |
|             320 | ST_POLYGONFROMTEXT                     |
|             335 | ST_POLYGONFROMWKB                      |
|             414 | ST_SIMPLIFY                            |
|             354 | ST_SRID                                |
|             364 | ST_STARTPOINT                          |
|             348 | ST_SWAPXY                              |
|             381 | ST_SYMDIFFERENCE                       |
|             393 | ST_TOUCHES                             |
|             382 | ST_TRANSFORM                           |
|             383 | ST_UNION                               |
|             415 | ST_VALIDATE                            |
|             394 | ST_WITHIN                              |
|             357 | ST_X                                   |
|             358 | ST_Y                                   |
|             874 | SUBCLASS_ORIGIN                        |
|             166 | SUBDATE                                |
|             907 | SUBJECT                                |
|             226 | SUBSTR                                 |
|             227 | SUBSTRING                              |
|             228 | SUBSTRING_INDEX                        |
|             167 | SUBTIME                                |
|             478 | SUM                                    |
|             921 | SUPER                                  |
|             168 | SYSDATE                                |
|             658 | SYSTEM                                 |
|             303 | SYSTEM_USER                            |
|              54 | TABLE                                  |
|             757 | TABLES                                 |
|             630 | TABLESPACE                             |
|             875 | TABLE_NAME                             |
|             118 | TAN                                    |
|             688 | TEMPORARY                              |
|             718 | TERMINATED                             |
|              79 | THEN                                   |
|             928 | THREAD_PRIORITY                        |
|              38 | TIME                                   |
|             170 | TIMEDIFF                               |
|              37 | TIMESTAMP                              |
|             171 | TIMESTAMPADD                           |
|             172 | TIMESTAMPDIFF                          |
|             259 | TIMEZONE                               |
|             173 | TIME_FORMAT                            |
|             174 | TIME_TO_SEC                            |
|             575 | TLS                                    |
|             638 | TO                                     |
|             229 | TO_BASE64                              |
|             175 | TO_DAYS                                |
|             176 | TO_SECONDS                             |
|             983 | TRADITIONAL                            |
|             233 | TRAILING                               |
|             751 | TRANSACTION                            |
|             984 | TREE                                   |
|             687 | TRIGGER                                |
|             959 | TRIGGERS                               |
|             234 | TRIM                                   |
|              16 | TRUE                                   |
|             119 | TRUNCATE                               |
|             631 | TYPE                                   |
|             235 | UCASE                                  |
|             908 | UNBOUNDED                              |
|             765 | UNCOMMITTED                            |
|             280 | UNCOMPRESS                             |
|             281 | UNCOMPRESSED_LENGTH                    |
|             639 | UNDO                                   |
|             236 | UNHEX                                  |
|             942 | UNINSTALL                              |
|             632 | UNION                                  |
|             633 | UNIQUE                                 |
|             177 | UNIX_TIMESTAMP                         |
|             925 | UNKNOWN                                |
|             756 | UNLOCK                                 |
|             909 | UNREGISTER                             |
|              20 | UNSIGNED                               |
|             852 | UNTIL                                  |
|             681 | UPDATE                                 |
|             262 | UPDATEXML                              |
|             634 | UPGRADE                                |
|             237 | UPPER                                  |
|             922 | USAGE                                  |
|             686 | USE                                    |
|             304 | USER                                   |
|             977 | USER_RESOURCES                         |
|             934 | USE_FRM                                |
|             693 | USING                                  |
|             178 | UTC_DATE                               |
|             179 | UTC_TIME                               |
|             180 | UTC_TIMESTAMP                          |
|             542 | UUID                                   |
|             543 | UUID_SHORT                             |
|             544 | UUID_TO_BIN                            |
|             282 | VALIDATE_PASSWORD_STRENGTH             |
|               4 | VALUE                                  |
|             545 | VALUES                                 |
|              45 | VARCHARACTER                           |
|             946 | VARIABLE                               |
|             960 | VARIABLES                              |
|             481 | VARIANCE                               |
|              46 | VARYING                                |
|             479 | VAR_POP                                |
|             480 | VAR_SAMP                               |
|             929 | VCPU                                   |
|             305 | VERSION                                |
|             641 | VIEW                                   |
|             679 | VIRTUAL                                |
|             635 | VISIBLE                                |
|             640 | WAIT                                   |
|             456 | WAIT_FOR_EXECUTED_GTID_SET             |
|             457 | WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS      |
|             961 | WARNINGS                               |
|             181 | WEEK                                   |
|             182 | WEEKDAY                                |
|             183 | WEEKOFYEAR                             |
|             238 | WEIGHT_STRING                          |
|              80 | WHEN                                   |
|             694 | WHERE                                  |
|             854 | WHILE                                  |
|             252 | WITH                                   |
|             752 | WORK                                   |
|             652 | WRAPPER                                |
|             753 | WRITE                                  |
|             910 | X509                                   |
|             768 | XA                                     |
|              74 | XOR                                    |
|             142 | YEAR                                   |
|             184 | YEARWEEK                               |
|             143 | YEAR_MONTH                             |
|              21 | ZEROFILL                               |
|             265 | ^                                      |
|             263 | |                                      |
|             268 | ~                                      |
+-----------------+----------------------------------------+
985 rows in set (0.01 sec)

mysql> select * from help_keyword where name='abs';
+-----------------+------+
| help_keyword_id | name |
+-----------------+------+
|              90 | ABS  |
+-----------------+------+
1 row in set (0.00 sec)

🔥 单条件查询 🔥

where子句（单条件查询）

在SQL中，insert、update、delete和select后面都能带where子句，用于插入、修改、删除或查询指定条件的记录。

SQL中使用where子句语法

SELECT column_name FROM table_name WHERE column_name 运算符 value

运算符	描述
=	等于
<> 或 !=	不等于
>	大于
<	小于
>=	大于等于
<=	小于等于
between and	选择取决于两个数据之间的范围；在MySQL相当于>=并且<=；

 🔥 多条件查询 🔥 

where子句（多条件查询）

and、or运算符语法

SELECT column_name FROM table_name WHERE condtion1 AND condition_2 OR condition_3

在where子句中，使用android、or可以把两个或多个过滤条件结合起来

运算符	描述
and	表示左右两边的条件同时成立
or	表示左右两边一个条件成立

创建表 （create table employee）

mysql> create table employee(id int not null auto_increment primary key,
name varchar(30) comment '姓名',sex varchar(1) comment '性别',
salary int comment '薪资（元）');
Query OK, 0 rows affected (0.02 sec)

插入数据

 insert into employee(name,sex,salary) values ('张三','男',5500);
 
 insert into employee(name,sex,salary) values('李四','男',4500);
 
insert into employee(name,sex,salary) values('张小妹','女',4500);

查询数据

 select * from employee;
+----+--------+------+--------+
| id | name   | sex  | salary |
+----+--------+------+--------+
|  1 | 张三   | 男   |   5500 |
|  2 | 李四   | 男   |   4500 |
|  3 | 张小妹 | 女   |   4500 |
+----+--------+------+--------+

按条件查询数据 

select * from employee where sex='女';
+----+--------+------+--------+
| id | name   | sex  | salary |
+----+--------+------+--------+
|  3 | 张小妹 | 女   |   4500 |
+----+--------+------+--------+

select * from employee where sex!='女';
+----+------+------+--------+
| id | name | sex  | salary |
+----+------+------+--------+
|  1 | 张三 | 男   |   5500 |
|  2 | 李四 | 男   |   4500 |
+----+------+------+--------+

select * from employee where sex <> '女';
+----+------+------+--------+
| id | name | sex  | salary |
+----+------+------+--------+
|  1 | 张三 | 男   |   5500 |
|  2 | 李四 | 男   |   4500 |
+----+------+------+--------+

select * from employee where salary > 4500;
+----+------+------+--------+
| id | name | sex  | salary |
+----+------+------+--------+
|  1 | 张三 | 男   |   5500 |
+----+------+------+--------+

select * from employee where salary between 4500 and 5500;
+----+--------+------+--------+
| id | name   | sex  | salary |
+----+--------+------+--------+
|  1 | 张三   | 男   |   5500 |
|  2 | 李四   | 男   |   4500 |
|  3 | 张小妹 | 女   |   4500 |
+----+--------+------+--------+

select * from employee where sex = '男' and salary > 4500;
+----+------+------+--------+
| id | name | sex  | salary |
+----+------+------+--------+
|  1 | 张三 | 男   |   5500 |
+----+------+------+--------+