是否有可能从程序中获取信息？ [英] Is it possible to get info from procedure?

问题描述

即时启动程序

i想从没有任何参数的程序中选择。

是否可能？

我怎么能通过它到php？

im starter in procedure
i want to select from procedure without any in parameter.
is it possible?
how can i pass it to php?

CREATE DEFINER=`root`@`localhost` PROCEDURE `Select_State`(OUT `State_ID2` INT(4), OUT `Name2` VARCHAR(50) CHARSET utf8)
BEGIN
SELECT * FROM state;
END

我有这个表格结构=>状态（StateID，Name）

i想要设置Name2 = Name和State_ID2 = StateID



我尝试过：



其他代码网址：http：//uupload.ir/files/pzuq_1.png

i无法保存。

i have this tables structure => State(StateID, Name)
i want set the Name2 = Name and State_ID2 = StateID

What I have tried:

an other code url: http://uupload.ir/files/pzuq_1.png
i couldnt save it.

推荐答案

所以我不太确定你的问题，但我想你想用你可以用PHP运行的SQL做一个更新语句。



我认为你打算做的就是这些。

So I'm not quite sure based on your question but i think you want to do an update statement using your SQL that you can run in PHP.

I think what you've intended to do is something along these lines.

UPDATE <your table name here> SET StateId2 = (SELECT StateID FROM state), Name2 = (SELECT Name FROM State);

这篇关于是否有可能从程序中获取信息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！