Skip to content

Venugopal

PHP – Wordpress – Joomla – Developer

  • WordPress Tutorial
    • How To Create A Custom Page Template In WordPress
    • How to Make Secondary Menu in wordpress
    • WordPress Pages
    • Wp Date & Time
    • Categories On page
    • WordPress Helpful Code Snippets
    • Custom filed
    • Current Page ID in wordpress
    • Query Posts
    • Reference – Content url
    • Dynamic Categories related Posts
    • WP Query in wordpress
    • WP-Quey – Post & Page Parameters
    • WP Query – Category Parameters
    • Query post page navigation in wordpress
    • How to get the Current Page ID in wordpress
    • How To Limit Characters in content WordPress
    • How to get custom values outside Loop
    • How to get all posts in wordpress
    • WordPress Cheat Sheet
  • Plugins
  • Git Commands
  • Javascript Tutorial
    • Show or Hide Password in Javascript
    • Radio button validation in javascript
    • Checkbox validation in javascript
    • limit textarea characters in javascript
    • Functions in Javascript
    • JavaScript Redirect
    • Show Image Before Upload
  • PHP Tutorial
    • JQuery , Ajax and PHP Example
    • PHP Create, Read, Update and Delete (CRUD) Application Tutorial
    • Stored Procedure Lesson in PHP
  • Free CodeIgniter Tutorial
  • Form Tips
    • Html5 Form with Captcha
  • Contact Me
Home2016March

Month: March 2016

Update record if exists, else write new record

March 21, 2016March 21, 2016 Venugopal Worpress Tutorial

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

Venugopal

Venugopal

Categories

  • introduction (1)
  • Uncategorized (2)
  • Worpress Tutorial (30)

Archives

  • March 2016
  • December 2015
  • August 2015
  • November 2014
  • August 2014
  • June 2014
  • January 2014
  • September 2013
  • June 2013
  • April 2013
  • March 2013
  • December 2012

Blog Stats

  • 116,250 hits

Top Posts & Pages

  • Radio button validation in javascript
  • How To Limit Words and Characters in content Wordpress
  • Html5 Form with Captcha
  • How To Create A Custom Page Template In WordPress
  • Stored Procedure Lesson in PHP
  • Client side File Size Limit in javascript
  • PHP Create, Read, Update and Delete (CRUD) Application Tutorial

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 60 other followers

RSS Live Cricket Score

  • Islamabad United v Quetta Gladiators
    Islamabad United v Quetta Gladiators
  • Western Australia 369/5 v South Australia 71/1 *
    Western Australia 369/5 v South Australia 71/1 *
  • Afghanistan 73/5 * v Zimbabwe
    Afghanistan 73/5 * v Zimbabwe

Follow me on Twitter

My Tweets

Blogs I Follow

Blog at WordPress.com.
Translate WordPress

Making WordPress Speak Your Language

Make WordPress Themes

Everything Around WordPress Themes

LMNITRIX

Venugopal

PHP - Wordpress - Joomla - Developer

Developer Resources

Create cool applications that integrate with WordPress.com

The WordPress.com Blog

The latest news on WordPress.com and the WordPress community.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy