Inserted data in the table. If I execute select query, I can see the data inserted. But once I execute commit, then execute select query on the same window, no record found.
It is looks strange. Don't know what is the issue.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
I found the reason. It is a Global Temporary Table, where the table is created as ON COMMIT DELETE ROWS.
