创建临时表时不同选项
create tmp table tmp_t (id int) on commit delete rows | on commit drop | on commit preserve rows
on commit delete rows选项,就是事务结束,数据就消失(事务级别)
on commit drop选项,可以设置事务结束临时表就消失(事务级别)
on commit preserve rows选项,事务结束时,数据依然还会存在,直到会话结束为止(会话级别)
创建临时表时不同选项
create tmp table tmp_t (id int) on commit delete rows | on commit drop | on commit preserve rows
on commit delete rows选项,就是事务结束,数据就消失(事务级别)
on commit drop选项,可以设置事务结束临时表就消失(事务级别)
on commit preserve rows选项,事务结束时,数据依然还会存在,直到会话结束为止(会话级别)