mysql delimiter

[j-marvin]

The example uses the mysql client delimiter command to change the statement
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.

hi -

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.

thanks,
jim

[j-marvin]

oops...that is only for mysql 5.
hmm... i wanted to wrap some deletes in a begin end type transaction.
i will have to look around to see how to go about it.

thanks,
later

[j-marvin]

i think this works except autocommit is a problem.
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
php 5?

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)
thanks.

later,
jim

<?php

mysql_pconnect( "localhost","ro ot","mynewpassw ord");
mysql_select_db ("mysite");
$res=mysql_quer y("BEGIN WORK");
mysql_query("de lete from page where page_id<10");
mysql_query("de lete from word where page_id<10");
mysql_query("de lete from occurrence where page_id<10");
$result=mysql_q uery("COMMIT");
print($res);
print ($result);

?>

[j-marvin]

"j-marvin" <cu******@servi ce.boy> wrote in
news:Xn******** *************** ***@24.24.2.165 :

i think this works except autocommit is a problem.
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
php 5?

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)
thanks.

later,
jim

oh...
i am going to use start transaction and commit.
that is all i need. there is no autocommit setting i need to turn
off or on in php with mysql. using start transaction and commit do it for
me.

thanks

[kingofkolt]

"j-marvin" <cu******@servi ce.boy> wrote in message
news:Xn******** *************** ***@24.24.2.167 ...

"j-marvin" <cu******@servi ce.boy> wrote in
news:Xn******** *************** ***@24.24.2.165 :

i think this works except autocommit is a problem.
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
php 5?

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)
thanks.

later,
jim

oh...
i am going to use start transaction and commit.
that is all i need. there is no autocommit setting i need to turn
off or on in php with mysql. using start transaction and commit do it for
me.

thanks

Do you always talk to yourself out loud?

[j-marvin]

"kingofkolt " <je**********@c omcast.net> wrote in
news:DmfUc.1372 09$8_6.7889@att bi_s04:

"j-marvin" <cu******@servi ce.boy> wrote in message
news:Xn******** *************** ***@24.24.2.167 ...

"j-marvin" <cu******@servi ce.boy> wrote in
news:Xn******** *************** ***@24.24.2.165 :

> i think this works except autocommit is a problem.
> who said anything about front base? i need to set this

thanks

Do you always talk to yourself out loud?

sometimes i am the only person who will talk to myself.