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?