This is a discussion on Views with parameters within the MySQL Database forums, part of the Database Forums category; How can I create views with parameters? example CREATE VIEW `db_collaudo`.`VWX`(IN PID INT) AS SELECT * FROM foo where ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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? |