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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.