mysql操作合集

1、mysql命名规范 https://blog.csdn.net/weixin_40172337/article/details/114491981
2、MySQL 5.7常见数据类型 https://www.jb51.net/article/217486.htm
3、 navicate 导出 数据库文档
https://blog.csdn.net/Wwt819635881/article/details/105419403?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165583168816781435451329%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=165583168816781435451329&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2allfirst_rank_ecpm_v1~rank_v31_ecpm-1-105419403-null-null.142v20huaweicloudv1,157v15new_3&utm_term=navicate+%E5%AF%BC%E5%87%BA+%E6%95%B0%E6%8D%AE%E5%BA%93%E6%96%87%E6%A1%A3&spm=1018.2226.3001.4187
例子
SELECT
TABLE_NAME 表名,
COLUMN_NAME 代码,
COLUMN_COMMENT 名称,
COLUMN_TYPE 数据类型,
COLUMN_KEY 主键,
COLUMN_COMMENT 注释
FROM
INFORMATION_SCHEMA.COLUMNS
where
– flowershop 为数据库名称，复制粘贴改为你的数据库名称即可
table_schema =‘flowershop’
– 输出所有该数据库所有表含字段
order by table_name

eg:

数据结构
SELECT
TABLE_NAME 表名,
COLUMN_NAME 字段名,
COLUMN_TYPE 数据类型,
COLUMN_KEY 主键,
COLUMN_COMMENT 名称
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema =‘financial_liquidation’

4、mysql中设置表中字段值唯一 https://blog.csdn.net/cj5213/article/details/107224407?ops_request_misc=&request_id=&biz_id=102&utm_term=mysql%E6%95%B0%E6%8D%AE%E8%A1%A8%E5%AD%97%E6%AE%B5%E5%94%AF%E4%B8%80%E8%AE%BE%E7%BD%AE&utm_medium=distribute.pc_search_result.none-task-blog-2allsobaiduweb~default-0-107224407.142v32experiment_2_v1,185v2control&spm=1018.2226.3001.4187

4、MySQL中获取天、周、月等数据 https://blog.csdn.net/qq_40207293/article/details/112008937?utm_medium=distribute.pc_relevant.none-task-blog-2defaultbaidujs_baidulandingword~default-0-112008937-blog-125239338.pc_relevant_aa2&spm=1001.2101.3001.4242.1&utm_relevant_index=3