Posted 29 June 2006 - 11:47 AM
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.
Posted 30 June 2006 - 06:20 PM
Actually this might be easier...:
If you already have the data in the database, you can use something like the following:
UPDATE mytable SET mytextcolumn1=TRIM(BOTH '"' FROM mytextcolumn1), mytextcolumn2=TRIM(BOTH '"' FROM mytextcolumn2);
Posted 01 July 2006 - 12:40 AM
Use Mysql LOAD DATA INFILE to load the data and specify that quotes are used.
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users