MySQL Tutorials - index of FREE Tutorials for MySQL

(5)Backup Guide	(2)Basics
(3)Exporting	(9)Functions
(34)General Development	(21)General Guides
(11)Miscellaneous	(2)Tweaking

	MySQL Database Tutorials From Flash CS4 Tutorial (MySQL General Development)
Many people tell me they aren’t very fond of scripts, because the install frightens them a bit. And it’s true: creating a database, importing tables, your site’s root path… if you don’t know what you’re doing, this looks pretty complicated. Luckily, it is not, once you get the hang of it.

	Listing MySQL Over Multiple Pages in PHP From Ointment Games and Development (MySQL General Development)
Break up a list of MySQL records and display them over multiple pages. Also generate page numbers and linkages dynamically.

	Learn to carry out various tasks for a MySQL Cluster From ...site title missing... (MySQL Functions)
MySQL users will learn to add and configure multiple management nodes for monitoring the usage information of a cluster to ensure that a cluster does not run out of memory. They will also learn how to set up replication between clusters and use disk-based tables.

	How To: Reset a WordPress user Password using phpMyAdmin or MySQ From CodeCall Programming (MySQL Miscellaneous)
Reset a users password on Wordpress using database tools

	How To: Backup and Restore your MySQL Database(s) From CodeCall Programming (MySQL Backup Guide)
Learn how to backup and restore your MySQL databases

	Learn to Use Indexes to Optimize your MySQL servers Performance From ...site title missing... (MySQL General Development)
MySQL users will be able to create, drop, and modify indexes in order to efficiently hone their servers performance.

	Migrating a MySQL table using Oracle SQL Developer 1.5 From http://www.packtpub.com (MySQL Exporting)
The article describes in detail the steps you need to take in order to work with MySQL using Oracles latest developer tool, the Oracle SQL Developer 1.5. The article also describes the process of taking over a table in MySQL to Oracle 10G XE using this tool.

Getting Started with SQL Developer: Part 1 From ...site title missing... (MySQL Functions)

This article by Sue Harper is all about preparing your environment, installation, and getting started with SQL Developer. SQL Developer is easy to set up and use. The best way to learn is by practice, and for that you‘ll need a computer with access to an Oracle database and SQL Developer. This article assumes you have a computer with Microsoft Windows, Linux, or Mac OS X installed, and that you have access to an Oracle database. It focuses on the alternative installations available for SQL Developer, where to find the product, and how to install it. Once your environment is set up, you can follow a quick product walk-through to familiarize yourself with the landscape. You‘ll create a few connections, touch on the various areas available (such as the SQL Worksheet and Reports navigator), and learn about the control of the windows and general product layout.

How to reset sa Password if forgot or lost SQL password From happykaka (MySQL Functions)

Lost or forgot MS SQL passwords? MS SQL Server Password Unlocker helps to decrypt the master.mdf and resets the lost MS SQL password, including changing sa password. This MS SQL password recovery program has small size yet with a powerful numeracy; it resets sa passwords of any length and complexity with no fussy settings. Just one mouse clicking to reset the selected SQL passwords. Whether or not the SQL Server is installed in advance, MS SQL Server Password Unlocker accesses to the master.mdf file directly and lists all the users to the database. For accessing the master.mdf smoothly, the password recovery program detects and stops the running SQL Services automatically.

	Using the Data Tables plugin in jQuery 1.3 From ...site title missing... (MySQL General Guides)
From time to time, you will want to show data in your website and allow the data to be sorted and searched. In this chapter, we will look at: How to install and use the DataTables plugin How to load data pages on request from the server Searching and ordering the data

Create a real-life storefront application with Zend Framework From ...site title missing... (MySQL General Development)

This chapter explains how to create a storefront on your website using the Zend Framework. You will learn to implement a shopping cart which will allow the users of your website to select products edit and delete items.It also explains how to create Models that do not use a database, using Zend_Form to create highly customized form layouts, injecting the Model into the Form instances, and adding dynamic data to our forms.

	Copying data from one table to another in sql using php From SurfnLearn.com - Learning on the web! (MySQL General Guides)
In this short tutorial, I am going to show you how to transfer data from any column in a table to another in sql using php.

Agile works best in PHP. From ...site title missing... (MySQL General Development)

In this tutorial, we will cover the following: • Introductions to agile philosophy, including agile values and agile principles • Common problems and fears that developers face while developing a product • What is meant by agility and how it can help • Extreme programming principles • Advantages of agile process models • Team agility • Agile process models • Agile principles for the PHP project team

	Writing SELECT queries for SQL databases From CodeCall Programming (MySQL General Guides)
When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables.

	SQL Date Functions - Converting and Using From CodeCall Programming (MySQL Miscellaneous)
SQL provides a lot of functions for manipulating dates in a database. You can store values in a date field or a datetime field. If you store the dates as unix_timestamps you can get a lot more flexibility with dates. In fact, this is usually what is done when you are using PHP with the database.

	SQL Functions - Math Functions From CodeCall Programming (MySQL Miscellaneous)
Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others.

	SQL Functions - String Functions From CodeCall Programming (MySQL General Guides)
SQL provides a large amount of functions for string manipulations. Learn how to convert and use SQL Functions.

	SQL Encryption Functions From CodeCall Programming (MySQL General Guides)
There are two ways of securing data in a database: hashing and encryption. Hashing usually prevents you from obtaining the original string. Encryption allows you to obtain the original string (through decrypting). This is only possible if you know the encryption method, and the key that was used to encrypt it.

	MySQL DROP DATABASE Recovery From Web Development Stuff (MySQL Miscellaneous)
Is it possible to recover data destroyed by unintentionaly confirmed DROP DATABASE command? This tutorial answers this question and offers step-by-step procedure how to do it, if possible.

	Optimizing MySQL: Importance of JOIN Order From Web Development Stuff (MySQL Miscellaneous)
This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading!

	Optimizing MySQL: Performance Tuning Script From Web Development Stuff (MySQL Miscellaneous)
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy to use and offers valuable output for MySQL performance optimization.

	Optimizing MySQL: Log Slow Queries From Web Development Stuff (MySQL Miscellaneous)
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.

	Optimizing MySQL: Configuration Directives From Web Development Stuff (MySQL Miscellaneous)
This is the first part of MySQL Optimization mini series. In this tutorial we will go thru the MySQL configuration directives which have an influence on its performance.

	SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter From ...site title missing... (MySQL General Development)
Learn to use the WCF SQL Server Adapter to implement composite transactions, poll for data change and building a proxy service for the adapter.

	Import Structure and Data using phpMyAdmin 3.1 From ...site title missing... (MySQL General Guides)
In this extract from Marc Delisle‘s new book, ‘Mastering phpMyAdmin 3.1 for Effective MySQL Management’, users will learn to bring back exported data created for backup and transfer purposes. They will get an overview of the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL and CSV files.