mysql 用同一表中的另一行记录的字段赋值

CREATE TABLE `user` (
  `db_id` varchar(255) NOT NULL,
  `name` varchar(45) default NULL,
  `age` int(10) unsigned NOT NULL,
  `address` varchar(45) default NULL,
  PRIMARY KEY  (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

// 设置name='888'的age等于name='111' +10

update users u,(SELECT age FROM users where name="111") as t
set u.age = t.age+10
where name="888";