Learn MySQL Online Free
Introduction to MySQL Programming With PHP
• PHPMyAdmin: MySQL Database Management Software
• Creating a MySQL Database In Your Hosting Control Panel
• MySQL Data Types
• Back Up or Manually Make Copy of MySQL Databases Just in Case
Basics of Interacting with Your MySQL Database Through PHP Script
• Closing a MySQL Connection
• Creating Tables Through Script
• Insert Information into a MySQL Database
• Output or Retrieve Database Information
• Update Existing Database Information
• Delete Database Information
• Freeing Result Sets for Large Data Queries
MySQL Query Examples and Data Requests
• Obtain a Table Row Count From a Query Result Set
• Using LIMIT to Obtain a Specific Result Set
• Using the WHERE Clause with SELECT to Target Data
• Selecting Individual Fields for Optimized Queries
• Show Alternate Field if Target Field is Empty
• Select Random Entries From the MySQL Database
• Perform Arithmetic On MySQL Numeric Values (hit counter example)
• List the Newest or Oldest Items From a Database Table
