全部博文
-
编辑 删除
sql 表的复制 远方
只复制表结构 SQL SERVER: select * into ele_payee_account_rr from ele_payee_account where 1=2 ORACLE & MYSQL: create table ele_payee_account_rr as select * from ele_payee_account where 1=2 DB2: CREATE TABLE People LIKE Person 复制表中的数据 INSERT INTO test2 SELECT * FROM test WHERE Id<10 INSERT INTO test2(a,b,c) SELECT a,b,c FROM test WHERE Id<10
