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
The above statement is only true for the command line client and any
other interface which uses backslash this way (e.g. C/C++ strings).
Regards,
Benjamin.
On Wed, May 22, 2002 at 11:58:15PM +0200, [EMAIL PROTECTED] 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. Commands end with ; or \g.
> Your MySQL connection id is 441 to server version: 3.23.49-max
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> \u elba
> Database changed
> mysql> create temporary table TTable(Field1 mediumtext);
> Query OK, 0 rows affected (0.04 sec)
>
> mysql> insert into ttable (Field1) values ('\');
> '>
> '>
> '>
> '>
>
>
> That means that query ok message is skipped. The same problem occur if I try
> the same operation with blob data type. Please report me about this.
>
> Bruno
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
