表变量作为My sql存储过程中的参数

问题描述:

我可以将表变量作为参数传递给MySql中的存储过程

Can i pass table variable as a PARAMETER To a Stored Procedure in MySql

如果要将表作为参数传递到存储过程中-答案是否定的.只能传递标量值.

If you want to pass a table into the stored procedure as parameter - then answer is no. Only scalar values can be passed.

可以直接通过其名称访问该表;如果要使用该表名来构造和运行过程中的新查询,请查看

The table can be accessed by its name directly; if you want to use that table name to construct and run new query in procedure, then have a look at prepared statements.