| 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: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.01 | OS: | Windows (Win2k) |
| Assigned to: | Dean Ellis | CPU Architecture: | Any |
[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.
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 ('\');