Hello;
I have saved an Excel file with same fields as MySQL database(the first blank for auto-icrement) and with a "," at the end of each record(row) and nothing at end of each field. I saved as CSV (not Mac or Dos). Tried to upload to phpmyadmin but get the following error everytime. Do I have the wrong version? MySQL 4.0.14-nt
If I do, what can I do to easily upload these text files?
Thank you for help
Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\Backup\dot\uploadtemp\php673.tmp' INTO TABLE agencies FIELDS TERMINATED BY ','
MySQL said:
#1148 - The used command is not allowed with this MySQL version
