1.利用describe
describe tablenam
describe tablename ‘%na%‘;
2. 利用explain
explain tablename
3. show columns from 表名
show columns from tablename; show fields from tablename like ‘%name%‘;
Mysql 查看表结构
原文：https://www.cnblogs.com/xiaolee-tech/p/12159485.html
