Mysql查看表结构以及详细数据sql

SELECT
	TABLE_SCHEMA AS 库名,
	TABLE_NAME AS 表名,
	COLUMN_NAME AS 字段名,
	column_type AS 数据类型,
	( CASE WHEN column_key = 'PRI' THEN 'PRI:主键索引' WHEN column_key = 'UNI' THEN 'UNI:唯一约束索引' WHEN column_key = 'MUL' THEN 'MUL:普通索引' ELSE '普通字段' END ) AS 列在索引中的属性作用,
	IS_NULLABLE AS 是否为空,
	COLUMN_DEFAULT AS 默认值,
	COLUMN_COMMENT AS 字段注释,
	character_set_name AS 元数据存储编码字符集 
FROM
	INFORMATION_SCHEMA.COLUMNS 
WHERE
	TABLE_SCHEMA = 'jx_srgg' 
	AND TABLE_NAME = 'gc_jzst_single_apply';