MySQL Essentials

From Techotopia
Revision as of 18:09, 29 October 2007 by Neil (Talk | contribs)

Jump to: navigation, search

MySQL Essentials is an online book designed to provide everything a user needs to know to install, build, maintain and secure MySQL based databases.

Table of ContentsNext
About MySQL Essentials

  1. About MySQL Essentials

  2. Database Basics
  3. MySQL Database Architecture

  4. The mysql Command-Line Tool
  5. The MySQL Administrator Tool
  6. The MySQL Query Browser
  7. Creating New Databases and Tables with MySQL Administrator
  8. Creating Databases and Tables Using SQL Commands
  9. Updating and Deleting MySQL Tables
  10. Inserting Data into a MySQL Database
  11. Updating and Deleting MySQL Data
  12. Retrieving Data From a MySQL Database
  13. Sorting Data Retrieved from a MySQL Database
  14. Using WHERE to Filter MySQL Data
  15. Advanced MySQL Data Filtering - AND, OR, NOT and IN
  16. MySQL Wildcard Filtering using LIKE
  17. MySQL Regular Expression Searches
  18. Joining Tables in MySQL
  19. An Introduction to MySQL Views
  20. MySQL Calculations and Concatenations
  21. Manipulating Text in MySQL
  22. MySQL Mathematical Functions
  23. Working with Dates and Times in MySQL
  24. MySQL Data Aggregation Functions
  25. MySQL Users and Security

Table of ContentsNext
About MySQL Essentials