mysql的
/**查看表结构**/
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;