Removing Double Quotes

2011-11-02 Thread Adarsh Sharma 

Dear all,

I need to remove the quotes in text columns in a mysql table. It has 
more than 5000 rows.

In some rows there is values quoted with ". I want to remove them.

Below is the snapshot :

*ID /URL  
Country   Publication  /   
Description ...and so on*
2474http://www.times-standard.com/United States
Times-StandardCalifornia12009-10-22 10:34:39T
F75466090TFT
   TT
2475http://www.argentinastar.com/ArgentinaArgentina Star
   1-00-00 00:00:00000
   0   
2476"http://www.economist.com/countries/argentina/";
"Argentina""Economist ""The site gives research tools to 
search articles by subjects and backgrounds. DD in the date tag is 
written in the following format : 3rd for 3 2-00-00 
00:00:00000"N"
   0   
2477"http://www.ambito.com/english/";"Argentina"
"Ambito.Com""The date tage  show  on the right side main page
0-00-00 00:00:00T000
"N"0   
2570"http://en.apa.az/";"Apa"1-00-00 
00:00:00000
0   
2571"http://www.theazeritimes.com/";"Caspian ""The Azeri 
Times""last update on 18 Feb 2011"1-00-00 
00:00:00000
0   




Please let me know the efficient & easiest way to remove it.



Thanks

Re: libmysqlclient from source

2011-11-02 Thread Nick Khamis 
I should have mentioned that this is using mysql 5.5.15

Thanks Again,

Nick.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

libmysqlclient from source

2011-11-02 Thread Nick Khamis 
Hello Everyone,

I am looking to build just the mysql client, and not the entire server
from source.
Which cmake flags do I need to install just the mysql client/devel header files.
The actualy mysql server is on a different machine.

Thanks in Advance,

Nick.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reusing "ibdata1" space

2011-11-02 Thread Rozeboom, Kay [DAS] 
Thanks to everyone who replied to my question.


Kay Rozeboom
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: 515.281.6139   Fax: 515.281.6137
Email:  kay.rozeb...@iowa.gov




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org