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:
CREATE PROCEDURE testProc
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?