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....

Structured Query Language (SQL) is a server-side web language used to create and maintain data stored in databases on a server. While the language itself isn't difficult, it can be hard to learn...

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...

Inserting new rows into a MySQL table is accomplished with the INSERT command. For the most part, it will be necessary to insert data into the table all at once, but MySQL allows for you to insert...

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...

Rows from a MySQL SELECT query are returned in an arbitrary or unpredictable order. Since the return has more to do with internal hashing and search algorithms than it does with your data, the...

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...

The most basic operation in any SQL system is the SELECT query. In MySQL, programmers use SELECT to query a database in order to retrieve records. Using SELECT will return a number of rows from a...

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...

Backing up your database regularly is a good idea. This guide will walk you through the process and help you create a backup of a database using phpMyAdmin. To do this you will need the phpMyAdmin...

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...