Re: delimiter

2006-10-20 Thread Jay Pipes
On Thu, 2006-10-19 at 18:18 -0300, JoXo CXndido de Souza Neto wrote: > I tried to escape the pipe character but it does not work. > > I shall try to explain better what is happening. > > I have got a .sql file which create my whole database (including triggers). > > When i run it at phpmyadmin i

Re: delimiter

2006-10-20 Thread Jo�o C�ndido de Souza Neto
In my tests here i saw something strange. I tried to run my .sql file in the mysql prompt and it works fine. When i change my data structure and tried to run again, it gives me again the old error in create trigger (it was not changed). Then i copy whole code of creating triggers from my .sql f

Re: delimiter

2006-10-19 Thread Jo�o C�ndido de Souza Neto
I tried to escape the pipe character but it does not work. I shall try to explain better what is happening. I have got a .sql file which create my whole database (including triggers). When i run it at phpmyadmin it fails, then i tried to run a part of my .sql file which creates a trigger in a m

Re: delimiter

2006-10-19 Thread Dan Buettner
João, the pipe character | often needs to be escaped, usually with a backslash like so: \| Can you post the command you are running and the error you get? Dan On 10/19/06, João Cândido de Souza Neto <[EMAIL PROTECTED]> wrote: Hi everyone. I have getting a sintax error when i try to execute D

Re: delimiter in mysql client

2006-08-10 Thread Chris
Asif Lodhi wrote: Hi, I am replying back to my own post. Sorry, I forgot to mention that I am using mysql client on WinXP Pro SP2 and MySQL-5.0.22 is installed on the same machine. Any hints as to why mysql client is showing this behavior? The only thing you're changing is the delimiter? Ar

Re: delimiter in mysql client

2006-08-04 Thread Asif Lodhi
Hi, I am replying back to my own post. Sorry, I forgot to mention that I am using mysql client on WinXP Pro SP2 and MySQL-5.0.22 is installed on the same machine. Any hints as to why mysql client is showing this behavior? Thanks in advance, -- Asif On 8/4/06, Asif Lodhi <[EMAIL PROTECTED]> w