Guides for everyone on how to structure their data and setup their MySQL database tables efficiently and easily.
Total: 106
Showing: 15
Page 1 of 8
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.
Database Development MySQL / General Guides
Free to view, step by step, short tutorial on database development with MySQL. The tutorials have many flash illustrations, screen shots to get you started on MySQL the fastest and the easiest way.
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.