源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

获取缺失主键表信息的MYSQL语句

  • 时间:2021-09-18 11:31 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:获取缺失主键表信息的MYSQL语句
[u]复制代码[/u] 代码如下:
SELECT a.`TABLE_SCHEMA` AS DB_NAME , a.`TABLE_NAME` , a.`TABLE_ROWS` ,a.`ENGINE` -- , a.* FROM information_schema.`TABLES` a LEFT JOIN information_schema.`TABLE_CONSTRAINTS` b ON a.`TABLE_NAME` = b.`TABLE_NAME` AND a.`TABLE_SCHEMA` = b.`TABLE_SCHEMA` WHERE b.`TABLE_SCHEMA` IS NULL AND a.`TABLE_TYPE` = 'BASE TABLE' AND a.`TABLE_SCHEMA` NOT IN ('information_schema','test','mysql','performance_schema') ORDER BY DB_NAME ,a.`TABLE_ROWS` DESC ;
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部