List:General Discussion« Previous MessageNext Message »
From:Frank Piwarski Date:April 3 1999 10:58pm
Subject:Redefining default delimeters
View as plain text  
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^^,
Thread
Redefining default delimetersFrank Piwarski4 Apr
  • Redefining default delimetersMichael Widenius4 Apr
  • Re: Redefining default delimetersFrank Piwarski4 Apr
  • Re: Redefining default delimetersFrank Piwarski4 Apr