查询中的存储过程 [英] The stored procedure in the query

问题描述

有一个过程 GetFileList -顾名思义，将返回文件列表和更多选项.

There is a procedure GetFileList - returns, as the name implies, a list of files and a couple more options with them.

然后可以在查询选择中使用此过程吗?

Is it possible then to use this procedure in the query select?

类似这样的内容:select Field1 from Image where Field2 IN (call GetFileList ());

推荐答案

您应该将其更改为函数 http://www.databasejournal.com/features/mysql/article.php/3569846/MySQL-Stored-Functions.htm

you should change it to a function http://www.databasejournal.com/features/mysql/article.php/3569846/MySQL-Stored-Functions.htm

这篇关于查询中的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！