SQL Tutorial For Beginners MySQL / General Guides
In this tutorial, you will learn how to: Select data from a database; Filter data using Where clause; Sort data by Order; Use wildcards for smart search; Use aggregate functions; Insert data into a database; Update data in a database; Delete data from a database; Create, update and delete tables.
Tutorial: Advanced SQL MySQL / General Guides
SQL is perhaps, a very easy language, so here we will try to explore its advanced nature...so that you will see that you can do a lot more with SQL. More than just "select", "order by" and so on...
Fixing column encoding mess in MySQL MySQL / General Guides
Just had an interesting issue with an encoding mess on a column containing non-ASCII text. The solution was not immediately obvious so I decided it's worth sharing.
Installing phpPgAdmin MySQL / General Guides
This article will show you how to install the latest version of phpPgAdmin (currently 2.3) which allows you easier maintenance of your database.