Re: delimiter

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 Brow

Re: delimiter

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

Re: delimiter

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 lik

Re: delimiter

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

delimiter

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

Re: delimiter in mysql client

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 deli

Re: delimiter in mysql client

TED]> wrote: Hi, When I create scripts, I change the delimiter at the beginning of the create_table script from ";" (without quotes) to "//". At the end of the script, I change the delimiter back to the original ";". This is according to what is described in doc at

delimiter in mysql client

Hi, When I create scripts, I change the delimiter at the beginning of the create_table script from ";" (without quotes) to "//". At the end of the script, I change the delimiter back to the original ";". This is according to what is described in doc at www.mysql.c

Re: SQLquery: delimiter // - #1064 error

o: Dave Kennedy; mysql@lists.mysql.com Subject: RE: SQLquery: delimiter // - #1064 error Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. This is why phpAdmin is objecting. Here are a listing of the mysql client commands http://dev.mysql.com/doc/refm

RE: SQLquery: delimiter // - #1064 error

ssage- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 2:59 PM To: Dave Kennedy; mysql@lists.mysql.com Subject: RE: SQLquery: delimiter // - #1064 error Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. Th

RE: SQLquery: delimiter // - #1064 error

Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. This is why phpAdmin is objecting. Here are a listing of the mysql client commands http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html Regards David Logan Database Administrator HP Managed Services

SQLquery: delimiter // - #1064 error

Windows XP phpMyAdmin 2.7.0-rc1 MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED] The DELIMITER statement works in the command line, but not in phpmyadmin (see error below) mysql> DELIMITER // mysql> use mysql // Database changed mysql> PHPmyadmin ===

Re: MySQL 5 and 'delimiter'

Hello. For a pity I'm not familiar with Deplhi. > > Thanks. So it seems that it's only a command line statement. > > Any idea why I get the error when executing the full CREATE > from a Delphi VCL component? Weird thing is, the procedure > is saved to the database. > > With r

Re: MySQL 5 and 'delimiter'

> > Comments from: > > http://bugs.mysql.com/bug.php?id=12344 > > > > might be helpful. > > Thanks. So it seems that it's only a command line statement. > > Any idea why I get the error when executing the full CREATE > from a Delphi VCL component? Weird thing is, the procedure > is saved to the d

Re: MySQL 5 and 'delimiter'

gt; > I'm a bit puzzled about the DELIMITER statement. > > > > Is this a command-line SQL statement only, or is this actually processed > > on the server? > > > > And if it's a command-line thingy only, shouldn't I be able to execute > > something

Re: MySQL 5 and 'delimiter'

Hello. Comments from: http://bugs.mysql.com/bug.php?id=12344 might be helpful. "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi there, > > I'm a bit puzzled about the DELIMITER statement. > > Is this a command-line SQL statement only,

MySQL 5 and 'delimiter'

Hi there, I'm a bit puzzled about the DELIMITER statement. Is this a command-line SQL statement only, or is this actually processed on the server? And if it's a command-line thingy only, shouldn't I be able to execute something like: CREATE PROCEDURE P_AA() MODIFIES SQL DATA be

RE: Changing default delimiter

At 17:17 -0500 2/23/04, David Perron wrote: Thanks Garth. Actually Im trying to change the delimiter in the context of running a sql file from the command line - so in this case, I would want to change from tab to csv mysql -h db#-reports.adz -u readonly -p < script.sql > output.csv ads

RE: Changing default delimiter

Thanks Garth. Actually Im trying to change the delimiter in the context of running a sql file from the command line - so in this case, I would want to change from tab to csv mysql -h db#-reports.adz -u readonly -p < script.sql > output.csv ads12 -Original Message- From: Gart

Re: Changing default delimiter

I'm not sure in what context you want to change the delimiter, but here's the doc page on the LOAD DATA command which shows how to terminate (a.k.a. delimit) fields with different characters: http://www.mysql.com/doc/en/LOAD_DATA.html On Mon, 2004-02-23 at 13:53, David Pe

Changing default delimiter

Greetings - Been scouring the docs for this all day and I come up with nothing for 'delimiter' - Id like to change the default delimiter in mysql to something other than tab. Is there a command to do this, and what are the options? Thank you! David

RE: specifying a delimiter

On 04-May-01 [EMAIL PROTECTED] wrote: > Hi Paul, > > I am now confronted with another problem. I need to also provide a CSV > version. > I need to use , seperated and " protected text. I have a copy of phpMyAdmin > that will > export to this format, but I need to use this at the shell. > I h

RE: specifying a delimiter

>Hi Paul, >Thanks for the help. I was hoping to accomplish this with MySQl, but in the >end a script works just as good and this is just the first of several I am >using. For what it's worth I ended up using sed. Here is is if somone else >could use it: >sed "s/ /|/g" >^This is

RE: specifying a delimiter

age- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 02, 2001 9:38 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: specifying a delimiter > > > At 9:11 PM -0500 5/2/01, Paul DuBois wrote: > >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote:

Re: specifying a delimiter

At 9:11 PM -0500 5/2/01, Paul DuBois wrote: >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >>Hi, >>Being new to MySQL, I am having a problem getting output from it to the >>shell that is formatted the way I need. I need a table to be written to a >>file with a

Re: specifying a delimiter

At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >Hi, >Being new to MySQL, I am having a problem getting output from it to the >shell that is formatted the way I need. I need a table to be written to a >file with a delimiter. >something like : > >#!/bin/sh >mysql -uro

specifying a delimiter

Hi, Being new to MySQL, I am having a problem getting output from it to the shell that is formatted the way I need. I need a table to be written to a file with a delimiter. something like : #!/bin/sh mysql -uroot -ptest database < sql Then I run that script like this: ./script.sh > outp

change default delimiter

Hi, Can somebody help me, with changing the default delimiters of MySQL. For Example I want to change the single quotes that enclose a string in an INSERT statement to #. How can it be done. Thanks in advance. Shambhu kumar Singh. _ Chat