MySQL function dynamically executes different SQL statements

Create procedurecps ()begin DeclareTable_uservarchar( $)default 'User'; SetstrSQL=Concat'SELECT * from', Table_user); PrepareA fromstrSQL;ExecuteA;End；

There will be errors in this process.

How do I use SQL to execute strings?

Need to use prepare to precompile SQL

Prepare  from ' SELECT * from food '  Execute

This is possible.

What if the statement is mutable? Do you need variables to hold part of the information and what are the variables required?

So, if you want to use the session level variable, you must add the @ symbol before the variable.

Of course, using prepare can also use parameters like this:

I'm looking for a problem. A collection version of the information, refer to the link:

http://bbs.csdn.net/topics/350158591

MySQL function dynamically executes different SQL statements