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 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.
I believe the DELIMITER command is currently only a mysql client command (i.e. it only works in the command line client). Perhaps it works in the Query Browser; I don't use the GUI tools, so I'm not sure. > Is there some trouble using the delimiter comand by a php script? > > > > ""Dan Buettner"" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] > Joo, 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, Joo Cndido 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? > > > > -- > > Joo Cndido 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]