Anonymous

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