MySQL Useful Information and Tutorials

***RazorDOX*** · 01-01-2011, 09:47 PM,

The MySQL site:

Code:
http://dev.mysql.com/

Database Normalization:

One of the most important things of database development is understanding the concepts behind Database Normalization. This means setting up the proper structure of your tables and how they will work together to make your data retrieval as seemless as possible while minimizing data resources necessary to perform the output.

Code:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Hierarchical Data:

Managing hierarchical data can be tricky, but once you get an understanding of how to approach it, you will find this an important tool in your database development.

Code:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

A useful article written on the Adjacency List model:

Code:
http://sqllessons.com/categories.html

GUIs:

Code:
http://www.heidisql.com/

Code:
http://www.navicat.com/

Code:
http://www.phpmyadmin.net/home_page/index.php/

SQL Injections

Code:
http://www.unixwiz.net/techtips/sql-injection.html

PHP and MySQL

Code:
http://www.tuxradar.com/practicalphp/9/0/0

XAMP(a quick and seemless way to integrate PHP, MySQL, Apache, PERL, PHPMYADMIN on Windows, Solaris, Linux, Mac OS). Note you won't learn how to tune your applications here, but if you are looking to get them set up quickly and jump right in, I personally have found this to be a good set-up on WinXP. Caveat, the discussion boards on the site are in German.

Code:
http://www.apachefriends.org/en/xampp.html

SQL formatters:

These allow you to dump in the code you are using for a query and print it out in a much neater form.

Code:
http://www.sqlinform.com/

Code:
http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

***promg*** · 01-01-2011, 10:07 PM,

interesting, going to study that in!