0 rows updated when should have been 1

[expired user #6898]'s profile image [expired user #6898] posted 11 years ago in General Permalink
I saw the other thread for this error and did not see anything that would fix my problem.

This is the create code for my simple table:

CREATE TABLE `phonetoemail` (
`AccountID` INT(10) NOT NULL AUTO_INCREMENT,
`Email` VARCHAR(50) NULL DEFAULT '0',
`Phone` INT(11) UNSIGNED NULL DEFAULT '0',
PRIMARY KEY (`AccountID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2;


I created a sample entry and then tried to edit it, this is the update statement from the heidisql log:

UPDATE `phonetoemail` SET `Phone`=9025555555 WHERE `AccountID`=1;

This fails with the error "0 rows updated when should have been 1"

I am trying to connect to a MySQL 5 server and forget the previous version I was on but updated to 7.0.0.4381 and see the same issue. I am on a 32Bit Win7 computer too.

I tried to use this program a few times within the past year as coworkers have recommended it but any database I have tried connecting to have this problem, MySQL or MSSQL.

Does anyone know how I can correct this?
kalvaro's profile image kalvaro posted 11 years ago Permalink
Weird. I get this other error rather than yours:

SQL Error (1264): Out of range value for column 'Phone' at row 1


The error is of course self-explanatgory: the maximum size for an unsigned INT is 4294967295 and 9025555555 is greater than that.

Not sure if your complaint is about not seeing the actual error. Are you using the "Data" tab?

[1] http://dev.mysql.com/doc/refman/5.1/en/integer-types.html
[expired user #6898]'s profile image [expired user #6898] posted 11 years ago Permalink
Yes I was using the data tab, that error would have helped me identify the problem much better, I miscounted and thought I had enough room for 1-902-555-5555. Thank you.

Please login to leave a reply, or register at first.