MySQL Forums
Forum List  »  Newbie

Is it possible to split a column data and create 2 different columns from that data
Posted by: ziauddin mohammed
Date: March 17, 2010 02:30PM

Hi,

I have a column called LogPath which has data like /192.168.2.100/Production/Sample1/Mar/WebLogs-2010-01-01.log.

I am trying to create or add 2 new columns to the existing table namely LogServer and LogDate. I want to take the data from LogPath field and split it and enter 192.168.2.100 in LogServer field and 2010-01-01 in the LogDate field.

I can write a java program and run this. But the issue is that for 300 million records it takes couple of hours.

Is there a simple and easy and fast way of doing this. If I am asking too much then I can over look simple and easy but have to stick to the fast.

Fast = Max 1 hour.

Thanks a lot, waiting eagerly for your help,

mzahmed

Options: ReplyQuote


Subject
Written By
Posted
Is it possible to split a column data and create 2 different columns from that data
March 17, 2010 02:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.