Menu
In MySQL, when I try to insert a backslash into my table, it does not accept it and gives me the content without the backslash.
id is set to auto increment:
Code:
INSERT INTO gender (sex, date) VALUES ( 'male are allowed \ female are not allowed', "2012-10-06") How do I insert a literal backslash?
Notes about escape sequences:
Escape Sequence Character Represented by Sequence \0 An ASCII NUL (0x00) character. \' A single quote (“'”) character. \" A double quote (“"”) character. \b A backspace character. \n A newline (linefeed) character. \r A carriage return character. \t A tab character. \Z ASCII 26 (Control+Z). See note following the table. \\ A backslash (“\”) character. \% A “%” character. See note following the table. \_ A “_” character. See note following the table. 
581
To search for “\”, specify it as “\\\\”; this is because the backslashes are stripped once by the parser and again when the pattern match is made, leaving a single backslash to be matched against.
In ANSI SQL, the backslash character (\) is the escape character. To search for data that begins with the string \abc , the WHERE clause must use an escape character as follows: ... where col1 = '\\abc';
Use 4 backslashes as per below: snowflake. createStatement( { sqlText: `insert into log_table (message) values ('\\\\newdata')` } ).
You need to escape your backslash :
INSERT INTO gender (sex, date) VALUES ( 'male are allowed \\ female are not allowed', "2012-10-06") Reference (with the list of all characters you must escape for mysql)
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
