try using a double slash "\\" - the first one acts as the escape character.
also works for the '
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 6:52 AM
Subject: Help with a putting a slash into a record
Try prefixing the \ (the ***x escape character) with a \, i.e.:
update test set f2 = 'c:\\temp' where f1 = 'location'
HTH,
Tore.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 5:52 PM
Subject: He
I have mysql installed on Red Hat 7.3. I have created a table like the
example below:
create table test(f1 char(30), f2 char(30))
Here is my problem I am trying to update this table with this:
update test set f2 = 'c:\temp' where f1 = 'location'
There is already a record with location in f1, bu
