multi-delimiter problem for MySQL
Worldwide MySQL Meetup Message Board › multi-delimiter problem for MySQL
| Sean |
|
|
kinhong Brisbane, AU |
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





