MySQL Resource Center: MySQL Tutorials and Webcasts

MySQL Tutorials and Webcasts

Guide to Cost-effective Database Scale-Out

http://www.mysql.com/why-mysql/white-papers/mysql_wp_scaleout.php?rz=power

Whitepaper: "Guide to Cost-effective Database Scale-Out using MySQL."

Webinar Offerings From MySQL AB

http://www.mysql.com/news-and-events/web-seminars/

Check out the latest Webinar offerings from MySQL AB. Topics include MySQL 5.1, MySQL Cluster and more.

Sample MySQL Video Tutorials

http://www.computer-training-software.com/mysql.htm

Check out the free sample MySQL video tutorials including database basics and SQL basics.

Building a Simple Affiliate System in PHP/MySQL

http://www.devshed.com/c/a/MySQL/Building-a-Simple-Affiliate-System-in-PHPMySQL/

Tutorial: "Building a Simple Affiliate System in PHP/MySQL," by Roger Stringer. Topics include building the database, your settings, being common, look and feel, your index page, letting affiliates join, letting affiliates login, adding affiliate code to your site, managing affiliates and paying your affiliates.

MySQL AB

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

Tutorial from the MySQL AB site. Topics include connecting to and disconnecting from the server, entering queries, creating and using a database, getting information about databases and tables, using MySQL in batch mode, example of common queries, queries from the twin project, and using MySQL with Apache.

PHP/MySQL Tutorial

http://www.freewebmasterhelp.com/tutorials/phpmysql

Tutorial: "PHP/MySQL Tutorial," covers setting up a database, inserting information, displaying data, more outputs, single records and error trapping, updating and deleting, and finishing the script.

PHP MySQL Tutorial

http://www.php-mysql-tutorial.com/

Tutorial: "PHP MySQL Tutorial." Walks through the installation of Apache, PHP and MySQL. Discusses PHP, MySQL, connecting to the MySQL database, creating a MySQL database, inserting data into a MySQL database, getting the data, using paging data, using PHP to backup a MySQL database, form validation, creating a guestbook, uploading files to MySQL, creating a content management system (CMS), user authentication, finding Web hosting for PHP and MySQL, and more. Includes a shopping cart tutorial.

MySQL on Mac OS X

http://developer.apple.com/internet/opensource/osdb.html

Tutorial: "MySQL on Mac OS X." Topics include MySQL features and drawbacks, installing MySQL, configuring and compiling MySQL.

Creating a MySQL Connection with PHP/AJAX

http://www.johnwiseman.ca/blogging/?p=61

Tutorial: "Creating a MySQL Connection with PHP/AJAX," by John Wiseman. Includes sample code.

How to Set Up a Load-Balanced MySQL Cluster

http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

Tutorial: "How to Set Up a Load-Balanced MySQL Cluster," shows you how to configure a MySQL 5.0 cluster with two storage nodes and one management node.

How to Set Up Database Replication in MySQL

http://www.howtoforge.com/mysql_database_replication

Tutorial: "How to Set Up Database Replication in MySQL."

PHP and MySQL: Introduction

http://www.chauy.com/2005/11/php-mysql-tutorial-introduction/

Tutorial: "PHP and MySQL: Introduction." Discusses how you can use PHP and MySQL.

Backing Up and Restoring Your MySQL Database

http://www.chauy.com/2005/12/backing-up-and-restoring-your-mysql-database/

Tutorial: "Backing Up and Restoring Your MySQL Database."

MySQL Database Handling in PHP

http://www.chauy.com/2005/12/mysql-database-handling-in-php/

Tutorial: "MySQL Database Handling in PHP."

How Databases Work

http://www.chauy.com/2006/02/how-databases-work-oracle-mysql-mssql/

Tutorial: "How Databases Work," discusses MySQL, Oracle and MS SQL.

OpenOffice.org 1.0, ODBC, and MySQL

http://www.unixodbc.org/doc/OOoMySQL9.pdf

Tutorial: "OpenOffice.org 1.0, ODBC, and MySQL 'How to,'" by John McCreesh. Topics including joining OpenOffice.org 1.0 to MySQL using ODBC, Using the data source tools in OpenOffice.org 1.0, using data sources in other OpenOffice.org 1.0 programs and using the form AutoPilot.

PHP/MySQL Tutorial: Introduction

http://www.tizag.com/mysqlTutorial/

Tutorial: "PHP/MySQL Tutorial: Introduction," provides an introduction to databases and why you should use them, walks you through the installation and setup of MySQL. Additional topics include admin, syntax, database, connect, create table, insert, query, fetch array, select, where, order by, join, left join, update, delete, backup and more.

Beginner's Guide to PHP and MySQL

http://www.weberdev.com/ViewArticle.php3?ArticleID=22

Tutorial: "Beginner's Guide to PHP and MySQL," by Rafi Ton. Topics include viewing the database, adding an entry to the database, modifying and entry to the database and deleting an entry from the database.

Introduction to PHP and MySQL

http://www.vtwebwizard.com/tutorials/mysql/index.php

Tutorial: Introduction to PHP and MySQL discusses PHP programming, creating a test table in MySQL, basic selects, inserting, updating and deleting.

Introduction to MySQL

http://www.chauy.com/2005/11/introduction-to-mysql/

Tutorial: "Introduction to MySQL." Topics include gaining access to MySQL, Downloading and Installing phpmyadmin, creating database tables, inserting data into the MySQL table and displaying MySQL data.

Beginning MySQL Tutorial

http://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/

Tutorial: "Beginning MySQL Tutorial," by W.J. Gilmore. Topics include datatypes and tables, manipulating the database, advanced MySQL commands and more.