MYSQL

FGJ: Create:2022/11/08 Update: (2024-10-24)

.frm #
comment[40100] #
- https://stackoverflow.com/questions/9298368/in-mysql-what-does-this-mean-40100-default-character-set-latin1
select(\g|\G) #
- https://stackoverflow.com/questions/2277014/why-the-g-in-select-from-table-name-g
character,collation #
后缀英文释义描述
_ai accent insensitive 不区分重音
_as accent sensitive 区分重音
_ci case insensitive 不区分大小写
_cs case sensitive 区分大小写
_bin binary 以二进制方式比较
mysql对库和表的概览查询 #
查看服务器版本号：select version();
查看所有的数据库：show databases;
查看当前使用的库：select database();
查看当前库中存在的表：show tables;
查看其他库中存在的表：show tables from mysql;
mysql查看建表语句 #
show create table record_format_demo;
desc employees;
mysql查看数据库中表的状态 #
show table status in myemployees where name = 'record_format_demo'\G
用于显示当前会话的状态信息 #
包括当前使用的数据库、服务器版本、连接信息等
mysql> \s
clear command not work #
\! clear \! cls
- https://stackoverflow.com/questions/8807836/how-to-clear-mysql-screen-console-in-windows
Reference #

📓 Archive