Jump to content

Archived

This topic is now archived and is closed to further replies.

ICEcoffee

Update Query

Recommended Posts

Hi all

I have imported a table from an ODBC database into MySQL, but all the data in all the columns are surounded by quotation marks.

Can anyone tell me how to write a query I can execute, to update all fields, to delete said quotation marks.


Thanks for any help, it will save me hours of work.

Share this post


Link to post
Share on other sites
Do you have a "dumped" database in a text file?  Can you write a perl script (w/ a regular expression) to excise the quotes?  (Then reimport the data....)

Actually this might be easier...:

If you already have the data in the database, you can use something like the following:
[code]UPDATE mytable SET mytextcolumn1=TRIM(BOTH '"' FROM mytextcolumn1),
mytextcolumn2=TRIM(BOTH '"' FROM mytextcolumn2);[/code]

Share this post


Link to post
Share on other sites
Dump the data from ODBC DB into a csv file.

Use Mysql LOAD DATA INFILE to load the data and specify that quotes are used.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.