mysql如何查詢表字所有字段？

show?tables?[from?db_name];

SHOW?FULL?COLUMNS?FROM?table_name

mysql>?create?table?teacher??#?創(chuàng)建teacher表 ????->?( ????->?Id?int?(5)?auto_increment?not?null?primary?key, ????->?name?char(10)?not?null, ????->?address?varchar(50)?default?'No.1?Mid?school', ????->?year?date ????->?); Query?OK,?0?rows?affected?(0.02?sec)  mysql>?show?tables; +------------------+ |?Tables_in_school?| +------------------+ |?teacher??????????| +------------------+ 1?row?in?set?(0.00?sec)  mysql>?show?full?columns?from?teacher;??#?顯示teacher表的所有字段 +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+ |?Field???|?Type????????|?Collation?????????|?Null?|?Key?|?Default?????????|?Extra??????????|?Privileges??????????????????????|?Comment?| +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+ |?Id??????|?int(5)??????|?NULL??????????????|?NO???|?PRI?|?NULL????????????|?auto_increment?|?select,insert,update,references?|?????????| |?name????|?char(10)????|?latin1_swedish_ci?|?NO???|?????|?NULL????????????|????????????????|?select,insert,update,references?|?????????| |?address?|?varchar(50)?|?latin1_swedish_ci?|?YES??|?????|?No.1?Mid?school?|????????????????|?select,insert,update,references?|?????????| |?year????|?date????????|?NULL??????????????|?YES??|?????|?NULL????????????|????????????????|?select,insert,update,references?|?????????| +---------+-------------+-------------------+------+-----+-----------------+----------------+---------------------------------+---------+ 4?rows?in?set?(0.01?sec)  mysql>?drop?table?teacher;??#?刪除teacher表 Query?OK,?0?rows?affected?(0.03?sec)  mysql>?show?tables; Empty?set?(0.00?sec)  mysql>