Mysql查询表中字段信息

很多情况下我们需要查询某张表中的字段，获取所有的信息以下的提供两种查询方法：

desc "表名" 查询表的字段

SELECT
	table_name tw_project_taibao_dawanqv_forjava,
  Column_Name      AS 列名英文,
	data_type AS 数据类型,
	(
	CASE
			
			WHEN data_type = 'float' 
			OR data_type = 'double' 
			OR data_type = 'TINYINT' 
			OR data_type = 'SMALLINT' 
			OR data_type = 'MEDIUMINT' 
			OR data_type = 'INT' 
			OR data_type = 'INTEGER' 
			OR data_type = 'decimal' 
			OR data_type = 'bigint' THEN
				NUMERIC_PRECISION ELSE CHARACTER_MAXIMUM_LENGTH 
			END 
			) AS '长度(整数)',
			NUMERIC_SCALE AS '长度(小数)',
			( CASE WHEN EXTRA = 'auto_increment' THEN 1 ELSE 0 END ) AS '是否自增',
 ( CASE WHEN IS_NULLABLE = 'NO' THEN 0 ELSE 1 END ) AS '能否为空', ( CASE WHEN COLUMN_KEY = 'PRI' THEN 1 ELSE 0 END ) AS '是否是主键',
			COLUMN_DEFAULT  AS '默认值'
		FROM
			information_schema.COLUMNS 
	WHERE
	table_schema = '#数据库名' and table_name = '#表名'