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!!!

<paolocarra@gmail.com> wrote in message
news:1149667340.939423.243060@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