Cita:
Iniciado por Neuron_376 Tu consulta:
INSERT INTO tabla_temp (id, name, mgroup, legacy_password, email, joined, ip_address, posts, title, allow_admin_mails, time_offset, hide_email, email_pm, email_full, skin, warn_level, warn_lastwarn, language, last_post, restrict_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_total, show_popup, misc, last_visit, last_activity, dst_in_use, view_prefs, coppa_user, mod_posts, auto_track, org_perm_id, temp_ban, sub_end, login_anonymous, ignored_users, mgroup_others, member_login_key, has_blog, subs_pkg_chosen) select name, min(id) from tabla_original group by 1
Dices que con esa consulta se resuelve tu problema verdad, bueno, lo que esta mal, es la parte del select...
INSERT INTO tabla_temp (id, name, mgroup, legacy_password, email, joined, ip_address, posts, title, allow_admin_mails, time_offset, hide_email, email_pm, email_full, skin, warn_level, warn_lastwarn, language, last_post, restrict_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_total, show_popup, misc, last_visit, last_activity, dst_in_use, view_prefs, coppa_user, mod_posts, auto_track, org_perm_id, temp_ban, sub_end, login_anonymous, ignored_users, mgroup_others, member_login_key, has_blog, subs_pkg_chosen) select name, min(id), [TODOS LOS CAMPOS QUE ESTAS TRATANDO DE INSERTAR] from tabla_original group by 1
Suerte!! Entonces seria asi:
INSERT INTO tabla_temp (id, name, mgroup, legacy_password, email, joined, ip_address, posts, title, allow_admin_mails, time_offset, hide_email, email_pm, email_full, skin, warn_level, warn_lastwarn, language, last_post, restrict_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_total, show_popup, misc, last_visit, last_activity, dst_in_use, view_prefs, coppa_user, mod_posts, auto_track, org_perm_id, temp_ban, sub_end, login_anonymous, ignored_users, mgroup_others, member_login_key, has_blog, subs_pkg_chosen) select name, min(id), [id, name, mgroup, legacy_password, email, joined, ip_address, posts, title, allow_admin_mails, time_offset, hide_email, email_pm, email_full, skin, warn_level, warn_lastwarn, language, last_post, restrict_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_total, show_popup, misc, last_visit, last_activity, dst_in_use, view_prefs, coppa_user, mod_posts, auto_track, org_perm_id, temp_ban, sub_end, login_anonymous, ignored_users, mgroup_others, member_login_key, has_blog, subs_pkg_chosen] from tabla_original group by 1 |