On Tuesday 25 July 2006 02:10 am, Jon wrote: > CREATE PROCEDURE sp_test1 (IN some_limit int) > select * from some_table limit some_limit; > > and > CREATE PROCEDURE sp_test2 (IN some_table table) > select * from some_table;
Well, first off with stored procedures the format is: DELIMITER $$ CREATE PROCEDURE name (....) BEGIN ...... END $$ DELIMITER ; DELIMITER is done so you can use ;'s within the stored procedure. The other thing too is that you're trying to select a table by a variable. That doesn't quite work, and I've tried a dozen or so variations myself hoping it would. You know, I'd almost LIKE someone to go "No you're wrong, you just need to do this..." ;) -- Chris White PHP Programmer/DBlast Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
