CODEWITHSUNDEEP
php
Moh'd Qassrawi
Moh'd Qassrawi

Reputation: 28

mysql duplicate data error

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'

Upvotes: 0

Views: 65

Answers (2)

datasage
datasage

Reputation: 19563

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

Upvotes: 2

Tularis
Tularis

Reputation: 1506

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 :)

Upvotes: 0

Related Questions