(Michael Kofler) This chapter discusses the fundamentals of relational databases, collects the varieties of data and tables available under MySQL, offers concrete examples of MySQL database structures, shows how indexes enable more efficient table access, and, finally, offers enlightenment on concr

(Gez Lemon) Released in January 1998, MySQL is an open source relational database management system (RDBMS). It’s based around the Structured Query Language (SQL), and is best for managing the content of the database as opposed to transactions, as MySQL does not support COMMIT or ROLLBACK. One of th

To maximize revenues and satisfy customer expectations, organizations must deliver ‘always on’ availability to company and customer information. This white paper describes how MySQL Cluster is able to cost-effectively meet the need for high availability database requirements. In this white paper you

(David Mytton) MySQL is commonly used by Web developers in conjunction with PHP. Although MySQL is not enabled by default in PHP5, a brand new class called MySQLi greatly enhances the functionality available to developers.

(Trudy Pelzer) Effective with MySQL version 4.1, there are two ways in which one can get data from multiple tables in a single query: with a join and with a subquery.

(Stephen Fishman) One of the most significant developments in the software and web development community in the past few years has been the increased use of open source software. It’s vital for any programmer, web designer, or other computer professional to understand that open source licenses a

(Robert Jones) I make my living building custom databases with web interfaces for biotechnology companies. These are MySQL and Perl CGI applications, running under Linux, and every one of them is different. Disaster recovery planning for these applications has consisted of routine tape backups of al

(Ulf Wendel) MaxDB by MySQL is one of the two enterprise level databases of MySQL AB. MaxDB has its origins in Adabas D which in 1997 was bought from Software AG by SAP, Europe’s largest software development company. SAP continued the development of the database and made it a stable, powerful and re

Welcome. This MySQL tutorial provides new MySQL users with very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time. MySQL runs under a broad arra

(Ian Gilfillan) MYSQL 4.1 has been released as a production version, and with all the new features it is likely a new generation of developers will soon be using MySQL. This month I revisit an old area of contention – subqueries. Until now, MySQL has not supported subqueries, and this lack cause