Hillary Posted June 5, 2009 Share Posted June 5, 2009 where would i put the 'Replace into table' code if i want to replace existing information in a table that still receives new information? this is not my table but i'm trying to help someone else and i dont have the code or the answer? if you can understand my question can you please help? THANKS!! let me know if you need any more information. Quote Link to comment https://forums.phpfreaks.com/topic/160994-replace-into/ Share on other sites More sharing options...
Ken2k7 Posted June 5, 2009 Share Posted June 5, 2009 I don't think REPLACE replaces existing information. You want UPDATE for that. Quote Link to comment https://forums.phpfreaks.com/topic/160994-replace-into/#findComment-849742 Share on other sites More sharing options...
gassaz Posted June 5, 2009 Share Posted June 5, 2009 Or you can use: INSERT INTO ....... VALUES .... ON DUPLICATE KEY UPDATE .... Quote Link to comment https://forums.phpfreaks.com/topic/160994-replace-into/#findComment-850278 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.