I'm having problems in uploading data from a text file into mysql which is in the same computer. The main problem is that i'm not able to use the 'load infile' command as there is no delimiters in the text file to seperate two fields.One field is just followed by another field with out any space or delemiters. This text file is automatically created backup file from a software, so i cant introduce any delimiters into it while creation of the file.
is there any solution for this???
looking forward for your help