hi i need to import data into a table in mysql from phpmyadmin using the Import option instead of using insert statements. for example if the table has 10 fields should the file that needs to be uploaded have the same field names on top and the associated values. ideally should this be as an excel or csv file or text file. in each case please advice the format in which the data needs to be added into the csv/txt file. please advice. thanks.
