Why PostgreSQL? The purpose of this article is to give you an idea about PostgreSQL. Most probably this will be an introduction for you. I will be providing a lot of links through out the…
Browsing Category SQL
#1093 – You can’t specify target table ‘table_name’ for update in FROM clause
Have you ever got this MySQL error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm. For the time…
How to do MySQL Indexing
MySQL Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1…
How To Reset My WordPress Admin Password?
Connect to the WordPress database via the phpMyAdmin tool at your web hosting account or open up a MySQL terminal to execute the below MySQL command. Once in phpMyAdmin select the WordPress database & Open…
Importing A Large mySQL Database Using BigDump
So you have a larger mySQL database of more than 30 MB size, you want to move it to a new server, and you’re unable to import your database to the new server via phpMyAdmin,…