Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- mysql delimiter
August 17, 2004, 5:28 am
rate this thread
delimiter from ; to // while the procedure is being defined. This allows
the ; delimiter used in the procedure body to be passed through to the
server rather than being interpreted by mysql itself.
i am using cli in interactive mode.
i tried changing the delimiter to // but everytime i type a ;
i get an error. what could i be doing wrong?
i just want to create a procedure.
Re: mysql delimiter
who said anything about front base? i need to set this
value from somewhere besides the mysql cli (like in php)
php 5 seems to make it easy. anyone know how to do it before
i am using myISAM mysql 4.0.13
i need to use InnoDB i think.
so i can autocommit all i want with the wrong table type
and it wont do me any good.
i will change my table types while i am waiting
for a response (i hope)
mysql_query("delete from page where page_id<10");
mysql_query("delete from word where page_id<10");
mysql_query("delete from occurrence where page_id<10");