Hello!
I am trying to update a record or insert it if it does not exist but I am having a hard time doing it and I canīt find where the problem is, can someone help me out and point me in the right direction
Code:INSERT INTO `jml_fl_users` ( `id`, `street`, `town`, `city`, `state`, `country`, `zipcode`, `coordinates`, `phone`, `website`, `favoritebook`, `aboutme`, `birthdate` ) VALUES( 54, '200 Cisnes', 'Lago de Guadalupe', 'Cuautitlán Izcalli', 'Mexico', 'Mexico', '54760', '19.6285952093597,-99.25037122265627', '6148356117', 'http://www.tlacaelelrl.com', 'gttry', 'rtyrty', '1983-01-04' ) ON DUPLICATE KEY UPDATE SET street = '200 Cisnes', town = 'Lago de Guadalupe', city = 'Cuautitlan Izcalli', state = 'Mexico', country = 'Mexico', zipcode = '54760', coordinates = '19.6285952093597,-99.25037122265627', phone = '6148356117', website = 'http://www.tlacaelelrl.com', favoritebook = 'gttry', aboutme = 'gttry', birthdate = '1983-01-04' WHERE id = 54;



Reply With Quote
Bookmarks