In MySQL, you can't modify the same table which you use in the SELECT part. … [Continue reading]
MySQL Error “Can’t specify target table for update in FROM clause” Solution
Netbeans: Using Chrome As The Default Browser
Netbeans (Programming IDE) and Google Chrome (Browser) are two of my favorite freeware applications. Getting netbeans to use Chrome as the default browser is easy and here's how. … [Continue reading]
Motivational Quotes: Realizing Your Goals
Setting a goal is usually easy. The hard part is actually doing it. It takes time, dedication, determination and the right mindset etc in order to achieve anything that's worth achieving in your book. … [Continue reading]
How To Remove Duplicate Lines with Notepad++
Use Notepad++ to remove duplicate lines/records from any text files. You can even sort the results alphabetically. I've previously used Excel to do this (in fact, I think most people use Excel) but this can be easily done in Notepad++ as well. … [Continue reading]
How To Install & Use Zen Coding In Notepad++, Faster HTML + CSS Coding
Zen coding is a pretty cool library that allows web developers to write html and css code faster. It buys you some time so you can work on more creative things instead of figuring out if your html/css tags are properly indented/closed. If this is the … [Continue reading]
Differences Between Encryption vs Encoding vs Hashing
Let's keep this short and just compare the facts. How are encryption, encoding and hashing different from each other? … [Continue reading]
Find & Compare Best Network Attached Storage (NAS)
I came across a pretty useful site today that helps people to find & compare Network Attached Storages (NAS in short). My media, projects and work files are starting to build up in different places/computers/laptops/netbook/iPhone/iPad and I … [Continue reading]
Opera IRC Client Rocks + How To Auto Identify & Join Channels
IRC is useful for lots of things. With IRC, you basically join a chat room to get help, help others or just to hang around. My favorite web browser Opera has a built-in IRC client which works just perfectly and had allowed me to get help from other … [Continue reading]
Turn Off Caching While Developing in CakePHP
Kept hitting CTRL+R, F5 or CTRL+F5 and don't see what you're expecting to see in your CakePHP App? This might have to do with the CakePHP internal caching and here's how to get pass it. … [Continue reading]
MySQL: Always Trim Your Data Before Loading Into MySQL
Here's a situation. There are 2 columns in a table which are identical. Identical as in having the same data type and collation (varchar(100) + utf8_unicode_ci) and having the same content. For example, let's say the table has 2 columns: a | … [Continue reading]