MySQL FAQs - Command-Line End User Interface mysql
A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats.

MySQL and SQL
This tutorial covers the following:
Introduction to relational databases and relational modeling; The MySQL command interpreter and the basic features of MySQL; Using SQL to create and modify databases, tables, and indexes. Using SQL to insert, delete, and update data; The SQL SELECT statement for querying, with examples of simple and advanced queries; Functions and operators in SQL and MySQL; Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL

[BEGINNER] The MySql basics
A powerfull tutorial about MySql, it will introduce you to the scripting language MySql.

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

Using a MySQL database with PHP
It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.

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, just let mysql do the work :-)

Introduction to MySQL
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database.

Build Your Own Database Driven Website Using PHP & MySQL: Part 4
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.

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 help mysql do the work faster, but you need to tell how...

Build Your Own Database Driven Website Using PHP & MySQL: Part 1
Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.

Understanding MySQL for PHP
Understanding MySQL for PHP is the new series of videos where I'm explaining what MySQL is and how to use it to create your own database. Every week we will be publishing the new video to add to this series.

MySQL Tutorials
Free, easy, step by step tutorials on MySQL development. It gets you started with MySQL the easiest and fastest way.

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 look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.

Using mysql in Batch Mode
You've probably used mysql interactively to enter queries and view the results. You can also run mysql in batch mode.

MySQL Date Queries
Don't use PHP to calculate date ranges; you can build the date range inquiry directly into your MySQL query. Here are some common examples of MySQL date queries.