Re: Backslash BUG?

2002-05-22 Thread 龔惠樑(Borus.Kung)
consider it, please~ :) Borus - Original Message - 寄件者: "Benjamin Pflugmann" <[EMAIL PROTECTED]> 收件者: "Bruno Batarelo" <[EMAIL PROTECTED]> 副本: <[EMAIL PROTECTED]> 傳送日期: 2002年5月23日 AM 06:58 主旨: Re: Backslash BUG? > Hi. > > Because the backslash i

Re: Backslash BUG?

2002-05-22 Thread Benjamin Pflugmann
Hi. Because the backslash is the escaping character and therefore has a special meaning, you have to escape it itself to get a plain backslash. I.e. mysql> insert into table (Field1) values ('\\'); This will insert one backslash. This is documented here: http://www.mysql.com/doc/m/y/mysql.html

RE: Backslash BUG?

2002-05-22 Thread domi
Hi Bruno !! Nope, the query OK is NOT skipped but the query has not been executed at all !! And this is not a bug !!! The backslash in Your query escapes the following single quote and the query will not be terminated by ";" . You should propably escape the backslash instead like this mysql> in

RE: Backslash BUG?

2002-05-22 Thread Gurhan Ozen
MySQL is doing the right thing, \' will mean single-quote character, so you will have to close it with another one. If you want to enter just a backslash do '\\' . See: http://www.mysql.com/doc/S/t/String_syntax.html Gurhan -Original Message- From: Bruno Batarelo [mailto:[EMAIL PROTECTE

Re: Backslash BUG?

2002-05-22 Thread Paul DuBois
At 23:58 +0200 5/22/02, Bruno Batarelo wrote: >Greetings > >I use latest stabile version of MySQL. Please, try to create temp table or >normal table and from mysql.exe try to insert a backslash symbol into a >field. Here is an example: > >Enter password: ** >Welcome to the MySQL monitor. Comm