Bug #3676 INSERT INTO table (field1,field2) VALUES ('\','...')
Submitted: 6 May 2004 14:20 Modified: 6 May 2004 18:20
Reporter: Martynas Kancleris Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.01 OS:Windows (Win2k)
Assigned to: Dean Ellis CPU Architecture:Any

[6 May 2004 14:20] Martynas Kancleris
Description:
I have table:

CREATE TABLE acronym (
  acronym char(20) ,
  description varchar(512) 
);

I try to insert row:

INSERT INTO ACRONYM (ACRONYM,DESCRIPTION) VALUES (':-\','Undecided')

(i tried with borland delphi+ado and bin\mysql.exe)

the row was not insert.

If I remove "\" simbol from insert sql then row insert.

How to repeat:
Create any table and try to run this sql with bin\mysql.exe:

INSERT INTO table (f1) VALUES ('\');
[6 May 2004 15:34] Philip
you are excaping hte quotes
you should write ... values('\\','...'_') instead of '\'
in pascal ther conceppt of excaped strings is missing
[6 May 2004 18:20] Dean Ellis
This is not a bug; as noted above you need to escape the backslash, otherwise it is trying to escape the apostrophe.