I'm working in Pset7. I've downloaded pset7.sql file, opened it with gedit, copied and pasted the file's content in phpMyAdmin's SQL text box then clicked GO. As in the pset7 instruction, I should see a green banner proclaiming Your SQL query has been executed successfully, but when click GO I saw this error:

enter image description here.

I don't know where I am wrong, please help me.


it means the table that you are trying to insert into already has a row where the ID = 1, and since this field is designated as Primary Key it won't allow duplicates of the same value here. Perhaps you already tried this query and it inserted once before. Try deleting that row or truncating the table and start again.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .