Here is the table structure. CREATE TABLE `UP_UserEx` ( `UserId` INT(11) NOT NULL, `UserNationality` CHAR(2) NOT NULL DEFAULT '', `UserProvince` CHAR(2) NOT NULL DEFAULT '', `UserCity` CHAR(4) NOT NULL DEFAULT '', `HomePhone` VARCHAR(32) NOT NULL DEFAULT '', `WorkPhone` VARCHAR(32) NOT NULL DEFAULT '', `OtherPhone` VARCHAR(32) NOT NULL DEFAULT '', `PersonalEmail` VARCHAR(64) NOT NULL DEFAULT '', `WorkEmail` VARCHAR(64) NOT NULL DEFAULT '', `OtherEmail` VARCHAR(64) NOT NULL DEFAULT '', `PrimaryEmail` SMALLINT(6) NOT NULL DEFAULT '0', `Company` VARCHAR(128) NOT NULL DEFAULT '', `CompanyWebsite` VARCHAR(128) NOT NULL DEFAULT '', `Occupation` VARCHAR(64) NOT NULL DEFAULT '', `JobTitle` VARCHAR(64) NOT NULL DEFAULT '', `Interest` VARCHAR(128) NOT NULL DEFAULT '', `Profile` VARCHAR(256) NOT NULL DEFAULT '', `Phrases` LONGTEXT NOT NULL, `LunarAnimal` SMALLINT(6) NOT NULL DEFAULT '0', `Horoscope` SMALLINT(6) NOT NULL DEFAULT '0', `BloodType` SMALLINT(6) NOT NULL DEFAULT '0', `ReservedFlag` INT(11) NOT NULL DEFAULT '0', `ReservedXml` LONGTEXT, PRIMARY KEY (`UserId`) ) ENGINE=INNODB DEFAULT CHARSET=utf8
The lock table timeout error display when I use the following statement. UPDATE UP_UserEx SET Phrases ='' WHERE UserID = 1; I don't know why? Thanks for your patient read. -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn Comanpy: http://www.actionsky.com
