表变量作为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.