MySQL Procedures

software development

#1

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

BEGIN

SELECT * FROM ‘testTable’

END;

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?

HELP PLEASE!!!


#2

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’;