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