mysql視圖和存儲過程的區別，mysql 視圖調用存儲過程,是否可以在視圖中調用存儲過程？

A similar question about sql-server has been asked here. I'm wondering if its possible in MySql.

edit:

I want to use result set returned from procedure in view.

mysql視圖和存儲過程的區別、解決方案

If you want to get result-set and use routine in FROM clause - NO. Stored routines (procedures or functions) in MySQL cannot return tables as result value.

But you can use functions as simple values, for example -

DELIMITER $$

mysql用什么軟件？CREATE FUNCTION mul10(Param1 INT)

RETURNS INT(11)

BEGIN

RETURN Param1 * 10;

mysql修改視圖影響原數據嗎、END

$$

DELIMITER ;

CREATE OR REPLACE VIEW view1

jdbc調用存儲過程、AS

SELECT mul10(2) AS column1;

SELECT column1 FROM view1;

----------

sql怎么調用存儲過程，20