Jobs!
Meetups by TopicMeetups by CityStart a MeetupWhat's Meetup
Home > All Topics > Internet & Technology > Software > MySQL Meetups Everywhere

Sponsored by: MySQL AB

multi-delimiter problem for MySQL

Worldwide MySQL Meetup Message Board › multi-delimiter problem for MySQL

Sean
kinhong
Brisbane, AU
1st Post

hello there,
I have a text file, each record in the file have 5 fields, these fields are separated by 2 types of delimiter....SPACE and TAB.

Now, I tried to use "load data infile" to load this file into my MySQL database, but how to
split the records with 2 delimiters?

the Format of the record is:

Word_0[SPACE]Word_1[SPACE]Word_2[SPACE ]Word_3[TAB]Number_0

any one help?

thank you!

Powered by mvnForum