Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

import CSV file into MySql table in PhpMyAdmin

Status
Not open for further replies.

SashaBuilder3

Programmer
Jan 13, 2002
129
CA
Hello there!

I am trying to import some data from a CSV file into an existing table in MySql database using phpMyAdmin.

I’ve created and saved a CSV file GU_t_rf_imgTp.csv, here it is:
q1_sd0a7o.jpg


Now in phpMyAdmin I do: first, I choose the table which to fill (in this case “GU_t_rf_img_type”). Then I click on the Import tab. Here I select the file, accept all the default settings, specify 1 query to skip (field names line), and click go.

q2_bbnn3t.jpg


All looks good, the top line message says “Import has been successfully finished, 6 queries executed. (GU_t_rf_imgTp.csv)”.

q3_b5f7fo.jpg


However when I go to Browse tab the table is empty:

q4_ecwera.jpg



Can anyone tell me what I am doing wrong?
Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top