how to combine string together for the execution of MySQL
Posted on 2013-10-29
As you all know that in MS SQL, I can combine string and variable from a query result set to become a Query for MySQL to execute once it is done.
set @var1 = 'select * from' + @var2 + 'where' + @var3 + '= 3'
might I know how can I do in MySQL ? CONCAT() ? it seems not !
what I wnat to do is to scan all table name from information_schema:
SELECT DISTINCT TABLE_NAME
Then create the respective DBAudit_<table name> in other database, please help.