mysql duplicate data error

Question

I'm facing a weird problem with my PHPmyAdmin while inserting query! it shows that the data are duplicate but it doesn't, here's the error message bellow:

Error SQL query: Edit

INSERT INTO  `a5693029_mydb`.`student` (

`stuID` ,
`stuName` ,
`stuMajor`
)
VALUES (
'20120176106', NULL , NULL
)

MySQL said: Documentation

#1062 - Duplicate entry '2147483647' for key 'PRIMARY'

datasage · Accepted Answer · 2014-02-03 21:03:44Z

2

You need to change the definition of StuId. It cannot store numbers larger than 2147483647 (signed 32 bit limitation)

edited Feb 3, 2014 at 21:03

answered Feb 3, 2014 at 20:49

datasage

19.7k2 gold badges51 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tularis · Accepted Answer · 2014-02-03 20:49:23Z

0

Looks like you have a field in your table that as hit its maximum value. Increase the fieldsize to be able to insert another row.

You have a ton of rows :)

answered Feb 3, 2014 at 20:49

Tularis

1,5061 gold badge8 silver badges17 bronze badges

1 Comment

datasage Over a year ago

To me it looks like a combined key, not an auto-increment issue. The 2012 looks like year and 01 may be January. The rest could be incremented though.

Collectives™ on Stack Overflow

mysql duplicate data error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related