mysql> create table missing_uids as select uid from users where uid not in (select uid from users_params); Query OK, 74 rows affected (0.08 sec) Records: 74 Duplicates: 0 Warnings: 0 mysql> insert into users_params (uid) select uid from users where uid not in (select uid from users_params); Query OK, 74 rows affected (0.07 sec) Records: 74 Duplicates: 0 Warnings: 0 mysql> update users_params set name = 'auth', value = '1' where uid in (select * from missing_uids); Query OK, 74 rows affected (0.87 sec) Rows matched: 74 Changed: 74 Warnings: 0