摘要: @ 复制表结构create table table_name_new as select * from where 1=2; --复制表结构和数据 create table table_name_new as select * from @ 查看表信息select * from tabs where table_name ='' --判断表是否存在 select count(*) from tabs where table_name =''@ 查看表字段信息select * from cols where table_name=upper('') 阅读全文
posted @ 2013-08-09 15:18 爱笑的狐狸 阅读(167) 评论(0) 推荐(0) 编辑