在sqlserver 下想復制一張表的，想到oracle下直接create table xxx as select * from ....即可。但是結果卻是錯誤的，baidu一下發(fā)現。sqlserver的語法是 : select * into tablenew from tableold
CREATE TABLE #TemTable AS SELECT * FROM PlatformCoinExchangeRecord;
SELECT * INTO #TemTable FROM PlatformCoinExchangeRecord;
SELECT * FROM #TemTable;
DROP TABLE #TemTable;
CREATE TABLE #TemTable
(TotalOnlineDuration bigint,
ByPlayDuration int,
TotalPlayTimes int,
Task30 int,
Task60 int,
Task120 int);
INSERT INTO #TemTable exec NET_PW_GetPlayDurationTask 539;
SELECT * from #TemTable;
DROP TABLE #TemTable;
臨時表可能創(chuàng)建后可能應為其他原因導致沒有執(zhí)行到drop，這樣下次執(zhí)行的時候臨時表還存在，所以創(chuàng)建臨時表以后最好會是做異常處理在catch中強制銷毀。
CONTINUE HANDLE mysql可以用這個東西
CREATE TEMPORARY table IF NOT EXISTS alarmLeveltb
( devID bigint not null,
alarmLevel bigint not null
);
truncate TABLE alarmLeveltb;--清空表中的數據
如果不存在某個表就創(chuàng)建，mysql寫法
IF objectproperty(object_id(@DbTableFileName),'IsUserTable') IS NOT NULL
PRINT 'EXISTS '
ELSE
PRINT 'NOT EXISTS '
貌似沒有找到直接創(chuàng)建的辦法，所以要約定好結果集