SQL error I've never seen!

VooDooRT

This is aggravating!
I try to enter this info and it's not wanting to work:

INSERT INTO orders SET name = "SSgt Parr", shop = "Weapon Maint.", nomenclature = "Indicator Breech", nsn = '9999-99-999-9999', part_num = '7631221-10', quantity = '2', date = "Jan 17, 2003", rec = '0', ser_num = '', JCN = ''

1062: Duplicate entry '127' for key 1

What the heck is that error all about? I just used it a moment before and it worked fine, but now, it doesn't want to work correctly. Ideas?

bastien

have combined INSERT and UPDATE sql statement syntax here...usually set refers to updating a specific column...

it should be either:

INSERT INTO orders (name,s hop, nomenclature, nsn, part_num, quantity, date, rec, ser_num, JCN) values("SSgt Parr", "Weapon Maint.", "Indicator Breech", '9999-99-999-9999', '7631221-10' , '2', "Jan 17, 2003", '0', '', '')

UPDATE orders SET name = "SSgt Parr", shop = "Weapon Maint.", nomenclature = "Indicator Breech", nsn = '9999-99-999-9999', part_num = '7631221-10', quantity = '2', date = "Jan 17, 2003", rec = '0', ser_num = '', JCN = ''" where somthing = something usually primary key

hth

xblue

Bastien, this is not a syntax problem (see http://www.mysql.com/doc/en/INSERT.html version 3).

VooDooRT, check the type of the column. if it is auto-incrementing but tinyint, it will default to the highest possible value a tinyint may have (127) in case it encounters any values higher than that, but this id would probably already exist in the database (which is what the error states).

Simply change the type to smallint, int etc., that's it. There range is listed here:
http://www.mysql.com/doc/en/Numeric_types.html