ICEcoffee Posted June 29, 2006 Share Posted June 29, 2006 Hi allI 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. Quote Link to comment Share on other sites More sharing options...
Wildbug Posted June 30, 2006 Share Posted June 30, 2006 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] Quote Link to comment Share on other sites More sharing options...
Barand Posted July 1, 2006 Share Posted July 1, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.