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 file and past it to mysql prompt and it works fine. My system admin told me that it could be a mysql bug. Someon here know something about that? ""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] >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 mysql prompt and it works fine. > > Is there some trouble using the delimiter comand by a php script? > > > > ""Dan Buettner"" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] > 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 DELIMITER | in my >> mysql >> 5 server. >> >> Could anyone help me about it? >> >> -- >> João Cândido de Souza Neto >> Curitiba Online >> [EMAIL PROTECTED] >> (41) 3324-2294 (41) 9985-6894 >> http://www.curitibaonline.com.br >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]