MySQL insert into table with auto-increment while selecting

2013年7月21日 - You simply set the primary key to NULL during the insert. insert into rt_table NULL, select rt_user_id, (select user_name from users u where u.user_id ...

stackoverflow.com