mysql中查看表结构相关sql

    /**查看表结构**/  
    desc yourtablename  
    /**查看创建表语句**/  
    show create table yourtablename  
    /**查看所有列的信息**/  
    use information_schema;  
    select * from columns where table_name='yourtablename';  
    /**查看所有列名的信息**/  
    use information_schema;  
    select column_name from columns where table_name='yourtablename';  
    /**拼接列名到预定义的sql**/  
    select concat('insert into yourtablename values(',r.column_name) from   
    (select group_concat(column_name) column_name from columns where table_name='yourtablename') r;  
    /**查询mysql中包含指定列的所有表名称和注释**/  
    useinformation_schema;  
    selectdistinctc.table_name,t.TABLE_COMMENTfromcolumnscleftjointablest  
    onc.table_name=t.TABLE_NAME  
    wherec.TABLE_SCHEMA='database'/**数据库名称*/  
    andc.COLUMN_NAME='password'/**列名称*/  
    andc.DATA_TYPE='int'/**数据列类型*/