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]