I need to accomplish a purely administrative scripting task in mysql and I'd like to do it without writing a perl or php script or something.

Given the following `Table A`:

```
user_id | permission
--------------------
1         1
4         1
298       1

```

How would I give every `user_id` present in `Table A` the `permission` 5. (It needs to insert a new row for each `user_id` present in the table)