如何将数据表传递到mysql存储过程？ [英] how to pass data table into mysql stored procedure?

问题描述

如何将数据表传递到mysql存储过程？

解决方案

正如我在过去的答案 [ ^ ]，MySQL不支持表数据类型。你必须将数据数组传递给存储过程

请阅读：将数组传递给MySQL存储的例程 [ ^ ]

它也可能有用：


将数组传递给MySQL存储例程 [ ^ ]


如何将整数数组传递给mysql中的存储过程？ [ ^ ]


A.4 MySQL 5.6 FAQ：存储过程和函数 [ ^ ]

MySQL中的存储过程可以接收任何有效数据类型的参数 - 表格不是有效的数据类型......

https://dev.mysql.com/doc/refman/5.0/en/data-types.html [ ^ ]

how to pass data table into mysql stored procedure?

解决方案

As i mentioned in past answer[^], MySQL does not support table data type. You have to pass array of data into stored procedure

Please, read this: Passing Arrays to MySQL Stored Routines[^]

It might be helpfull too:

Pass array to MySQL stored routine[^]

How to pass an Integer Array to a Stored Procedure in mysql?[^]

A.4 MySQL 5.6 FAQ: Stored Procedures and Functions[^]

Stored procedures in MySQL can receive any parameter of valid data type - table is not a valid data type...
https://dev.mysql.com/doc/refman/5.0/en/data-types.html[^]

这篇关于如何将数据表传递到mysql存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！