Fast MySQL import
Posted on 2003-12-06
How do I post following text file to the MySql database?
1apple 245red 12.5
2banana 19 yellow25.4
5banana 12 yellow 25
Data format is always same:
Primarykey ddddd (4 digits) name nnnnnnnnn (9 Chars); count ddd (3 digits); color nnnnnn (6 chars); dddd (4 digits with decimal)
Each record is terminated with an end-of-line character.
Looking for a command that will post above sample info
(actual sample.txt has appx 30.000 records, and it needs to be able to do this in few seconds
Text file name: sample.txt
Database name: fruits ; Username: Admin ; Password: pass
Tablenames: name; count; color; weight
(I have tried Navicat, but it takes 5 minutes to do the import)