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