MySQL SQL语句收集

1,创建数据库并且UTF8编码

CREATE DATABASE {tablename} DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;

2,显示特定表的建表语句

show create table {tablename};

3,查看系统字符集设置

show variables like 'char%'

4,Oracle SQLDeveloper连接配置文件位置
C:\Users\{UserName}\AppData\Roaming\SQL Developer\system17.2.0.188.1159\o.jdeveloper.db.connection

5. 查看正在执行中的SQL

select * from information_schema.`PROCESSLIST`

6. 查看历史SQL

SET GLOBAL log_output = 'TABLE'; 
SET GLOBAL general_log = 'ON'; 

SELECT * from mysql.general_log ORDER BY event_time DESC;

7. 生成随机字符串

SELECT SUBSTRING(MD5(RAND()) FROM 1 FOR 32) AS str