Duplicate entry '1' for key 1

[kungmario]

Help, im getting this error when I try to upload part 1 of my SQL database thingy..

[code[Fel

SQL-fråga:

--

-- Dumping data for table admins

INSERT INTO admins ( aId , aUsername , aPassword , aPermissions )
VALUES ( 1, 'admin', 'f8c5a65f897fda65e5379b351f9f13e1b552781a', 'ALL' ) ;

MySQL sa: Dokumentation
#1062 - Duplicate entry '1' for key 1 [/code]

[bpat1434]

It means that the column aId already has a row with a value of "1" in it. So either you need to remove that row prior to running that insert, or modify the insert statement to a value that isn't in the table already.

[dagon]

perhaps you want aId to be auto incremented, then you don't need to specify the id, the db will take care of it for you.