Query:
INSERT INTO upsert_table(id, name, value) VALUES(4,"Check_Upsert",888) ON DUPLICATE KEY UPDATE name = VALUES(name), value = VALUES(value);
If id=4 already there in table it will update values else write the new record in table
Query:
INSERT INTO upsert_table(id, name, value) VALUES(4,"Check_Upsert",888) ON DUPLICATE KEY UPDATE name = VALUES(name), value = VALUES(value);
If id=4 already there in table it will update values else write the new record in table
Making WordPress Speak Your Language
Everything Around WordPress Themes
PHP - Wordpress - Joomla - Developer
Create cool applications that integrate with WordPress.com
The latest news on WordPress.com and the WordPress community.