I have test table called TEST1:
+----+-----------------+------------+
| id | context | Started |
+----+-----------------+------------+
| 1 | what ever | 2004-06-08 |
| 2 | second comments | 2004-06-08 |
+----+-----------------+------------+

I am creating the procedure called simpleproc in MySQL with input parameter, param1, then I want to return all rows where condition is - id=param1.
The syntax as I entered in MySQL:-
mysql> create procedure simpleproc (param1 int)
    -> BEGIN
    -> SELECT context,started FROM test1 WHERE id=param1;
ERROR 1064 (42000): 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 'SELE
CT context,started FROM test1 WHERE id=param1' at line 3
mysql>

What is this error 1064 ?, anyone knows, SQL syntax for SELECT is OK!

Please help!, thanks in adv guys.
Kasie

That is not a problem with SELECT syntax, the problem is that your procedure definition is incomplete.

Create Procedure

You have started with BEGIN, but where do you END your procedure?;)
Cheers!

_________________________
-Vijay G
Strive for Perfection