Can I create view with parameter in MySQL?

by

Actually if you create func:

create function p1() returns INTEGER DETERMINISTIC NO SQL return @p1;

and view:

create view h_parm as
select * from sw_hardware_big where unit_id = p1() ;

Then you can call a view with a parameter:

select s.* from (select @p1:=12 p) parm , h_parm s;

I hope it helps.

More Related Contents:

  1. MySQL : When stored procedure parameter name is the same as table column name
  2. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  3. Pass array to MySQL stored routine
  4. Connect By Prior Equivalent for MySQL
  5. How to raise an error within a MySQL function
  6. MySQL: View with Subquery in the FROM Clause Limitation
  7. MySQL stored procedure vs function, which would I use when?
  8. MySQL stored procedures use them or not to use them
  9. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  10. Looping Over Result Sets in MySQL
  11. mysql dynamic query in stored procedure
  12. MySQL : transaction within a stored procedure
  13. Dynamic table names in stored procedure function
  14. List of Stored Procedures/Functions Mysql Command Line
  15. passing LIMIT as parameters to MySQL sproc
  16. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  17. How do you debug MySQL stored procedures?
  18. MySQL view performance
  19. MySQL Stored Procedure Error Handling
  20. MySQL error #2014 – Commands out of sync; you can’t run this command now
  21. MySQL Stored Procedures not working with SELECT (basic question)
  22. How to schedule a stored procedure in MySQL
  23. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  24. How to use Table output from stored MYSQL Procedure
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. Call a stored procedure for each row returned by a query in MySQL
  27. Creating MYSQL Procedure in Laravel 4 Migrations
  28. is it possible to call a sql script from a stored procedure in another sql script?
  29. Mysql stored procedure don’t take table name as parameter
  30. How to pass a variable to a IN clause?

Leave a Comment