SQL Statement to find duplicate data
Sometime we just want to find any duplicate data in the table, this simple statement will help to get the list of duplicate data. SELECT field1,…
SQL Statement to update one table field with another table field
A simple statement to update one table field with another table field value. UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate =theValueTable.valueToUpdate
Way to compare 2 Tables data using SQL statement
Sometime we just need to compare left and right table to ensure the data are tally. There’s 2 SQL statement we can use to achieve this….
Setting Time Zone in PHP
Working on an oversea project lately which required to host the web application on different time zone server. It’s too troublesome to update every single PHP…
How to create batch file to Flash DNS
Sometime we need to flush the computer DNS record due to some changes of domain pointing. Instead of going to every computer and running the same…
VRider Reward Kit
Receive my VCR Reward kit from UltraVRider after my completion of VR 160KM Century Ride. The medal and jersey design was great. Thanks UltraVRider.
Disable Hosting Directory Viewing Using .htaccess
Most of the Linux hosting have directory browsing enabled, this allow people to view the content of individual folder (Directory) in your web server. For security…
Pancake without Milk
While preparing breakfast for wife then found out we don’t have milk. So, I used the following ingredients for my pancake. 1 cup of flour 3…
Why my Facebook Page can’t set location and operation hour?
There is a few category of Facebook Page, some category the business location and operation hour are disabled. If you like to setup the location and…
Can’t turn on my Garmin 520
When heading out for my daily ride and the Garmin 520 went sleep and refuse to turn on. At first I though it’s out of battery,…