Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
    当前位置：
    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

MySQL 中直接生成数据字典方法（需在设计时为表、字段写好备注）

A-A+
0
Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
2
Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
2.54 k
Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
百度已收录
Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
数据库
本文最后更新于2021-03-16，已超过 1年没有更新，如果文章内容、图片或者下载资源失效，请留言反馈，我会及时处理，谢谢！

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

温馨提示：本文共775个字，读完预计2分钟。


Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

只需将最后一行的 TABLE_SCHEMA 后的值修改为自己的表名即可。

在 Navicat 中查询后可以通过 导出结果 功能直接导出 Excel 表格，导出时记得勾上包含标题行~

SELECT
    a.TABLE_NAME AS '表名',
    b.TABLE_COMMENT AS '表备注',
    a.COLUMN_NAME AS '字段名',
    a.COLUMN_TYPE AS '数据类型',
    a.IS_NULLABLE AS '是否可空',
IF
    ( a.COLUMN_DEFAULT = '', '空字符串', IFNULL( a.COLUMN_DEFAULT, '无' ) ) AS '默认值',
    a.COLUMN_COMMENT AS '字段备注'
FROM
    information_schema.COLUMNS AS a
    JOIN information_schema.TABLES AS b ON a.TABLE_SCHEMA = b.TABLE_SCHEMA 
    AND a.TABLE_NAME = b.TABLE_NAME 
WHERE
    a.TABLE_SCHEMA = 'Database_Name' # 这里修改为数据库名
    # 单表时加上下方条件
    # AND a.TABLE_NAME = 'Table_Name' # 这里修改为表名
————————————————
版权声明：本文为CSDN博主「至天」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/maxsky/article/details/85131950


Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
本文链接：，转发请注明来源！

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
头像
作者 : Mr.Li
别总盯着眼前的困惑，读万卷书行万里路，你会发现眼前的事，都是小事。

猜您还喜欢


    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • MySQL 日期和时间戳的转换 | 以及DATE_FORMAT()用法2.25 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • MySQL 报错10552.14 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • MySQL 中直接生成数据字典方法（需在设计时为表、字段写好备注）2.54 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • 什么是数据库索引2.37 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • mysql高效率随机取一条或多条数据2.54 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • SQL 中 只查出日期最新记录3.22 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • sql语句中直接将时间戳转化为时间格式3.94 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • MySQL5.6 执行sql报错：[Err] 1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause3.06 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • SQL Server CONVERT() 函数3.6 k

    • Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

    Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
  • SQL Server DATEDIFF() 函数3.38 k

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924
评论已关闭。

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924

Warning: mysqli_query(): (HY000/1194): Table 'wp_options' is marked as crashed and should be repaired in /www/wwwroot/www.haimengli.com/wp-includes/wp-db.php on line 1924