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
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:58 PM
To: [EMAIL PROTECTED]
Subject: Backslash BUG?
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:
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
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. Commands end with ; or \g.
Your MySQL connection id is 441