This syntax is ofcourse used with LOAD DATA INFILE
-> fields terminated by ','
-> enclosed by '"'
-> lines terminated by '/r'
but can i do a similiar thing in an UPDATE statement to re-define field
temination along this line
fields-terminated-by '^^'
the reason being that i have a file that reads like this
UPDATE _remembrance set client = '_429UJ9JF',
SetTitle = 'Photo Gallery',
CountryCode = 'us',
Password = 'passMEthePossum',
Visible = 'true',
Expires = '12/1/2000',
AdGroup = 'zx3',
SetCode = '000',
Language = 'us',
template = 'cloud.jpg',
regnum = '_10350005399',
regco = 'Honest Johns Funeral Home',
regaddress1 = '1712 N. Harold's Ln.',
regaddress2 = 'State Rd. 46',
and i would like to use syntax like what follows. I am happy to
recompile to support this if that is possible.
UPDATE _remembrance set client = ^^_429UJ9JF^^
SetTitle = ^^Photo Gallery^^
CountryCode = ^^us^^
Password = ^^pass^^
Visible = ^^true^^
Expires = ^^12/1/2000^^
AdGroup = ^^zx3^^
SetCode = ^^000^^
Language = ^^us^^
template = ^^cloud.jpg^^
regnum = ^^_10350005399^^
regco = ^^Honest Johns Funeral Home^^
regaddress1 = ^^1712 N. Harold's Ln.^^
regaddress2 = ^^State Rd. 46^^,
