Problem in MySQL stored procedures

[Sudantha]

Hi guys i have a problem creating stored procedures in MySQL 5.1.45 through phpMyAdmin 3.2.4 , it ways give a SQL error 

 

#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 '' at line 4

 

Some how i manged to create two stored procedures and they are working properly , thing is even i change the variable names and procedure name and  use the same code and compile it gives the same error 

 

DROP PROCEDURE IF EXISTS getacc;.

 

 

CREATE PROCEDURE getacc( IN uname VARCHAR(50), OUT cbal VARCHAR(50))

 

SELECT account_balance INTO cbal FROM customers WHERE username=uname;.

 

[andrewgauger]

MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension. Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL syntax, which is basically the same thing.[/quote

 

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html