Mapping single column to two columns during load ops in MySQL

Vote count:

0

Below is my text file structure

id | u_name | url | date | time
1 | svk23 | www.google.com | 2013-10- 02 | 23

Below is my target table where I want to load the text file

id|datebin|u_name|url|date|time
1|2013-10-02|http://ift.tt/1odgaz5

I want to map date value to 'datebin' column during load ops...is it possible to do that in MySQl?

asked 1 min ago

user3632319

15