mysql 查询表中字段

mysql查询表中字段

desc tablename; show columns from tablename; describe tablename;

mysql 查询建表语句

show create table tablename;