mysql> CREATE TABLE foo (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, a INT(10), b INT(10), PRIMARY KEY (id)); Query OK, 0 rows affected (0.10 sec) mysql> INSERT INTO foo (a,b) VALUES (10,100); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM foo; +----+------+------+ | id | a | b | +----+------+------+ | 1 | 10 | 100 | +----+------+------+ 1 row in set (0.00 sec) mysql> UPDATE foo SET a=1