view with parameters

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
can I put parameters into a view?

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

Re: view with parameters

Quoted text here. Click to load it
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.


Site Timeline