Thursday, 8 August 2013

MySQL - Is there a way to change the ENCLOSED IN character for UPDATES?

MySQL - Is there a way to change the ENCLOSED IN character for UPDATES?

I am using EXCEL to create a group of UPDATE statement. A good number of
rows have columns that contain single quote characters as part of the
field value. Is there a way I can tell MySQL to use a different ENCLOSURE
character other than " or ' ?
It would be great to be able to change the character from the standard to
a specific. EXAMPLE -
UPDATE table SET length=~value~, width=~value~, etc.
Where ~ would be used in place of " or ' .

No comments:

Post a Comment