Hi there…
I’m here with a new question for you all 
I have a table which has 4 columns…
local_id owner_id friend_id friend_name
In my app, every time user logins, the app sends the friend list of the app owner to the database(mysql)… Since he/she logged in the friend list may have changed… So I have to retrieve it every time…
But when I insert new friend list to the table, it duplicates the old same ones…
Something like this:
local_id owner_id friend_id friend_name
1_________23________54________John
2_________23________54________John
I want it to ignore the entry which already in the table…
(local_id is auto increment id…)
I’m using this query to do this, but it won’t work…
INSERT IGNORE INTO FriendsTable (owner_id, friend_id, friend_name) VALUES (23, 54, John)
I thought this query will skip the entry if it already exist in the table…
But it doesn’t…
Any ideas?
