MySQL Procedures

software development


Hello - I’m new to DreamHost and am trying to figure out how to create a procedure in MySql. I have created a database named testDB (using the goodies/MySql page). So far, I’ve created one table named testTable. I added a dummy record into the table just to have something to work with. I’m trying to create a small procedure that will just select all the records in the table. I’m using the following syntax:



SELECT * FROM ‘testTable’


If I enter this into the SQL query box on my PHPMyAdmin page, I get this error message:

" #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 'begin "

What am I missing? Does DreamHost not allow procedures? Do I have to set up permissions to create procedures?



I haven’t even looked into stored procedures yet, but at first glance, perhaps you just need a semicolon at the end of the SELECT statement…?

SELECT * FROM ‘testTable’;