MySQL Forums
Forum List  »  General

View with parameters
Posted by: pao pao
Date: January 15, 2008 03:38PM

How can I create views with parameters?
example

CREATE VIEW `db_collaudo`.`VWX`(IN PID INT) AS
SELECT * FROM foo where id=PID;

this gets error.

With a stored procedure I can, but How car I call the result of a stored procedure within for example an INSERT statement
example

INSERT INTO TABLE
SELECT * FROM (CALL storedProc1());

this gets error.
How can I do that?

Options: ReplyQuote


Subject
Written By
Posted
View with parameters
January 15, 2008 03:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.