MySQL

If you need to convert an MS SQL or MS Access database to a MySQL database and either do or do not have access to the MS SQL server that contains the original database, then this article is for you.

MySQL is a free, open source database owned and developed by Sun Microsystems. Because of its wide use by the open source community, many user interfaces, such as the PHP-based phpMyAdmin, are...

The "Replace" command used in MySQL serves as a kind of "find and replace" function for databases; it can be used to update a name change, fix any possible spelling mistakes or change addresses....

Connecting a web page to a database is really the key function of large data-driven websites. All but the smallest websites use data, usually through MySQL databases, to dynamically generate...

All but the smallest websites these days use databases to organize their content. Instead of placing important content directly in HTML files, eventually resulting in thousands of files, new...

If you plan on building complex websites, eventually you are going to discover that it is all about data management, usually with SQL (Structured Query Language) code. MySQL is currently the most...

When working and writing scripts for a LAMP environment, not much effort or planning is taken into account during database design. Not until your database begins to crawl that you will investigate...

MySQL provides a number of aggregate functions for quickly compiling data from your tables. These aggregate functions work within SELECT queries, and their results return in special columns. The...

Technically there is no "fetch array" function in MySQL. It's a PHP function that interacts with a MySQL database. MySQL databases are not very useful if application code can't have easy access to...

With a MySQL database, the UPDATE command is used to change some columns of a row already in the database. Usually, this is done to keep information in a database current.

There are multiple ways to delete data from a database in MySQL. At times it may even be necessary to delete entire tables, since some tables are temporary--created to be the target of a SELECT...

There will be times when multiple users need to access the same database, at which point you will need to change the MySQL privilege table. Depending on user needs, you may provide limited or full...

When you need to add or modify information to a database located on the server, you'll need to connect to the MySQL server. In order to do so, you need to know its hostname, port and what username...

Creating a MySQL table utilizes the CREATE command and the "Data Definition Language," or DDL. DDL is used to define data structures. MySQL provides a number of column types. Each column holds a...

There are many reasons you could want to convert a MySQL database to a comma deliminated CSV file. This guide will walk you through the process. To do this you will need the phpMyAdmin software...

Creating a MySQL database is a relatively simple task. This guide will help you create a MySQL database using either the phpMyAdmin interface or the SSH (Secure Shell) command line.

There are many uses for the structured query language (SQL). In order to begin harnessing the power of an SQL or MySQL database, you need to create it. This guide will walk you through the steps...