Everyone a great god, and I recently met a problem, to replace the mysql database with dream database, but there is a temporary table mysql, replaced by da dream database after a temporary table does not support, excuse me what method can solve this problem?

CodePudding user response:

Grammar is different, mysql is inside the create temporary table XXX,
Dream in grammar is the create global temporary table XXX, and mysql is the temporary table session level, to dream can support level and transaction level of two types of the session