Mysql SQL statements to view table information

Mysql SQL statements, View table information, View table field information, Java code SELECT column_name AS 'column name', data_type AS 'data type', character_maximum_length AS 'character length ', numeric_precision AS 'numeric length', numeric_scale AS 'decimal', is_nullable AS 'whether to allow non-null ', case when extra = 'Auto _ increment 'THEN 1 ELSE 0 end as 'Auto increment?', column_default AS 'default ', column_comment AS 'note' FROM Information_schema.columns WHERE table_Name = 'test'; 2. display the data items in the database TABLE. Java code show table status from 'database _ name'; 3. display table name Java code show tables from 'database _ name ';