The MySQL stored procedure uses the variable to make the table name--Go

Original address: http://blog.csdn.net/business122/article/details/7528859

Today write a database to do a snapshot of the stored procedures, using the dynamic table name, suddenly found that MySQL does not support the direct use of variables to do the table name, Google down, using the following methods:

DECLAREDbNameVARCHAR( -); SETDbName= 'AAA'; SET @STMT:=CONCAT ("CREATE TABLE", DbName,"SELECTId fromgamedb; ");PREPARESTMT from @STMT; EXECUTESTMT; END 

Using preprocessed SQL

The MySQL stored procedure uses the variable to make the table name--Go