How to use ON DUPLICATE KEY in insert statement
Problem:
In case of inserting or updating record we use separate logic using if statement or case statement:
e.g.:
if(i==0)
insert here
if(i=1)
update here
we can terminate the above if statement by using On Duplicate Key.
by using this only one statement can be use for insert and update record.
*note: user_nm...
-
Get View Page Source, View, copy and download HTML code of any website page View Page source Utility I have developed this utility t... -
How to add comment in shopify Using comment and endcomment tag you can add any one line multiple lines comments in Shopify code. below...
-
Problem: change SurfaceView height width in android. You are using SurfaceView to open camera in Android. and want to set it's custo...
-
Use value in index method in Codeigniter <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); ...
-
Problem: If you are using iTestShap in Dot net application and generating PDF with owner passward. After that you are trying to open that...
-
Problem: I am wondering when you get the error 'System.Threading.ThreadStateException' while using OpenFileDialog in C# Winform a... -
Find lost Android Mobile’s location You have Android mobile and suddenly you lost it then how to find it’s location and Play sound in it so... -
My Services I am expert in Genuine Website Speed Optimization (Guaranteed REAL Pagespeed Performance 70-90+ Score ), On Page SEO, Off Pa... -
Problem: While uploading more that 100 KBs file size FileZilla could show you error message as below: "filezilla Error Connection ...
-
Video Cutter A Windows based Video cutter application. compatible with Windows 7, Windows 8,Windows 10 for 32 and 64 bit. You do not s...
Subscribe To
Posts
All Comments