view with parameters

[paolocarra]

can I put parameters into a view?
example
CREATE VIEW `dmz_sms`.`vwProva` AS
SELECT * FROM tb_sms where id=@ID;
I get error 1351, but I don't believe mySql don't allow parameters into
views!!!

[Rich Ryan]

<pa********@gmail.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...

can I put parameters into a view?
example
CREATE VIEW `dmz_sms`.`vwProva` AS
SELECT * FROM tb_sms where id=@ID;
I get error 1351, but I don't believe mySql don't allow parameters into
views!!!

My guess is that you can do this within a stored procedure, but my question
is why you are doing this. Not critizing, just interested. Your view is a
identical to the base table in terms of columns. So I'm wondering why you're
doing this.

Thanks,
Rich