menriquez Posted May 23, 2008 Share Posted May 23, 2008 yes i am having a dumb issue on a easy problem. all i want to do is take the email field from on table to create a user key field in another, so i am trying this... INSERT INTO scores (user_id) select email from contestants; i get a "duplicate key 0 in field 1" error, which means my select is return an integer and not the email string...whats up with that? - mark Link to comment https://forums.phpfreaks.com/topic/106920-solved-using-subquery-to-populate-new-table/ Share on other sites More sharing options...
menriquez Posted May 23, 2008 Author Share Posted May 23, 2008 oh never mind the used_id field was an integer not string...sorry - mark Link to comment https://forums.phpfreaks.com/topic/106920-solved-using-subquery-to-populate-new-table/#findComment-547993 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.