Hi all,

I have a table called users and another called temp_user_id.

Table temp_user_id has 5 columns:

Column Name Type Auto-Increment

menu_order_id int(11) Yes
user_id int(11)
menu_id int(11)
is_active tinyint(1))
ordering mediumint(8)

I want to select all user_id from the users table and insert them into the table temp_user_id with the values below in the other columns. The expected values are below:

menu_order_id Auto-Incremented ID
user_id user_id from users table
menu_id 10
is_active 1
ordering 100

Can anyone assist?