Advertisment

Optimizing MySQL, Hardware and the Mysqld Variables

You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to...

Views: 874 | | by Sean
MySQL - Miscellaneous

Optimizing MySQL Queries and Indexes

Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how...

Views: 904 | | by John
MySQL - Miscellaneous

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of...

Views: 874 | | by Jason
MySQL - Miscellaneous

MySQL Crash Tutorial

One of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to knowmethodically, systematically, and simply.

Views: 833 | | by Daniel
MySQL - Miscellaneous

How To Set Up Database Replication In MySQL

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master...

Views: 876 | | by Tutorial
MySQL - Miscellaneous

Mysql Sub Queries, introduction

Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP,...

Views: 801 | | by Donald
MySQL - Miscellaneous

Basic SQL optimization for MySql

It's important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They...

Views: 928 | | by Nick
MySQL - Miscellaneous

Running Multiple MySQL Versions

How to run multiple versions of MySQL on the same Server.

Views: 890 | | by David
MySQL - Miscellaneous

MySQL Migration: MyISAM to InnoDB

A tutorial explaining how to convert a production application from MyISAM format to InnoDB.

Views: 832 | | by Jason
MySQL - Miscellaneous

MySQL FAQs - Managing User Accounts and Access Privileges

A collection of 17 FAQs on MySQL user accounts and access privileges. Clear answers are provided with tutorial exercises on creating and deleting...

Views: 844 | | by Simon
MySQL - Miscellaneous

Introducing MySQL

In this tutorial, you'll learn what MySQL is, and the tools you can use when working with it.

Views: 870 | | by Ben
MySQL - Miscellaneous

Working with MySQL

In this tutorial, you'll learn how to connect and login to MySQL, how to issue MySQL statements, and how to obtain information about databases...

Views: 875 | | by Sean
MySQL - Miscellaneous

Retrieving Data

In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.

Views: 865 | | by Simon
MySQL - Miscellaneous

Sorting Retrieved Data

In this tutorial, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.

Views: 803 | | by Sarah
MySQL - Miscellaneous

Filtering Data

In this tutorial, you will learn how to use the SELECT statement's WHERE clause to specify search conditions.

Views: 880 | | by John
MySQL - Miscellaneous

Advanced Data Filtering

In this tutorial, you'll learn how to combine WHERE clauses to create powerful and sophisticated search conditions. You'll also learn how...

Views: 850 | | by Nick
MySQL - Miscellaneous

Wildcard Filtering

In this tutorial, you'll learn what wildcards are, how they are used, and how to perform wildcard searches using the LIKE operator for...

Views: 855 | | by Slicer
MySQL - Miscellaneous

Searching Using Regular Expressions

In this tutorial, you'll learn how to use regular expressions within MySQL WHERE clauses for greater control over data filtering.

Views: 807 | | by John
MySQL - Miscellaneous

Creating Calculated Fields

In this tutorial, you will learn what calculated fields are, how to create them, and how to use aliases to refer to them from within your application.

Views: 894 | | by Slicer
MySQL - Miscellaneous

Using Data Manipulation Functions

In this tutorial, you'll learn what functions are, what types of functions MySQL supports, and how to use these functions.

Views: 849 | | by Ben
MySQL - Miscellaneous