It is also possible to create a temporary table
. The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table. Use the
CREATE GLOBAL TEMPORARY TABLE
statement to create a temporary table. The
ON COMMIT
clause indicate if the data in the table is
transaction-specific (the default) or
session-specific.[@more@]
临时表分为两种 会话临时表和事务临时表
- 会话临时表指临时表中的数据只在会话生命周期存在,当会话结束后,自动truncate表中此session的数据;
- 事务临时表指临时表中的数据只在事务生命周期存在,当事务提交或者回滚后,自动truncate表中数据;
create global temporary temp_session(columns...) on commit preserve rows;--session temporary table
create global temporary temp_transaction(columns...) on commit delete rows;--transaction temporary table
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28758644/viewspace-1060876/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28758644/viewspace-1060876/