Lisa_Miss的博客

SELECT `hotel`.`id` AS `hotel_id`, `hotel`.`name`, `hotel`.`province_name`, `hotel`.`city_name`, `hotel`.`county_name`, `hotel`.`address`, `hotel`.`start_rating`, `hotel`.`latitude`, `hotel`.`longitude`, `hotel`.`thu...

SELECT C.TABLE_NAME AS '表名' , T.TABLE_COMMENT AS '表注释' , C.COLUMN_NAME AS '字段名' , C.EXTRA AS '主键', C.COLUMN_TYPE AS '数据类型' , C.IS_NULLABLE AS '允许为空', C.COLUMN_COMMENT AS '字段注释' FROM COLUMNS C INNER JOIN TABLES T ON C.TABLE_S...