(1)RDS for Mysql
常用的配置参数有:
# 密码策略
validate_password_policy
validate_password_length
# 慢查询时间
long_query_time
(2)获取表以及表结构数据
SELECT
A.TABLE_SCHEMA '数据库',
A.TABLE_NAME '表名',
A.COLUMN_NAME '表列名'
FROM INFORMATION_SCHEMA.COLUMNS A
WHERE A.TABLE_SCHEMA='db_hllcrm'
ORDER BY A.TABLE_SCHEMA,A.TABLE_NAME
一个表一条记录:
SELECT
A.TABLE_NAME '表名',
GROUP_CONCAT(A.COLUMN_NAME) '表列名'
FROM INFORMATION_SCHEMA.COLUMNS A
WHERE A.TABLE_SCHEMA='db_pay'
GROUP BY A.TABLE_NAME
ORDER BY A.TABLE_SCHEMA,A.TABLE_NAME