Update if record already exist else insert-MySQL

I am uploading an excel file into the database table, What I want is, If any record from excel sheet already exists into the table then update that record with the latest data which is available on the sheet. How to do that? Well, It is pretty simple Following is the syntax to perform that […]

Read More

Image Map On background Image-Responsive

Following is the code to use mapping in the responsive background image.  Code written here is for the rectangular image. First half[50%] of the image is linked to one URL, and another 50%[half] image is linked to another URL. /* HTML code for imap */ <div id=”demo”>  <a id=”link1″ title=”link1″ href=”#”></a>  <a id=”link2″ title=”link2″ href=”#”></a> </div> […]

Read More

Mysql Display 2 columns output into one

I have 2 columns(A & B), what I want to do is to display output into a single column. INPUT: A B 12 1 134 12 145 554 OUTPUT: A 12 134 145 1 12 554   To obtain this output we need to use the  ‘UNION’  operator.   So the query would go like: […]

Read More