HI all, am trying to execute this simple stored procedure by using phpmyadmin DROP PROCEDURE IF EXISTS p; CREATE PROCEDURE p () BEGIN SELECT * FROM `timezones` WHERE 1; END but am getting this error MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `timezones` WHERE 1' at line 3 any one help on this error
You have an error in the WHERE clause. Specify the column(s) and comparison operator(s) as needed to form the SQL statement. Also, check out http://dev.mysql.com/doc/refman/5.0/en/select.html