`

MySql根据表名获取表信息

阅读更多
  SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'tbl_name'
  [AND table_schema = 'db_name']
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics