查看mysql表相关信息

[size=large]在mysql中，除了可以使用[/size]

1，show columns from tableName
2，show create table tableName

[size=large]等操作来查看一个表的相关信息外，还可以用以下方式来查询：[/size]

[size=large]
查询表信息
[/size]

select * from information_schema.tables  where table_schema = 'databaseName' and table_name ='tableName';

[size=large]
查询表列信息
[/size]

select * from information_schema.columns  where table_schema = 'databaseName' and table_name ='tableName';