MySQL Tutorial

03 Sep 2003 | by | Filed in
Page 1 of 10
  1. Introduction
  2. Getting Started
  3. Creating and Deleting Databases
  4. Creating Tables
  5. Using Indexes
  6. Altering Tables
  7. The SELECT statement
  8. The INSERT statement
  9. The UPDATE statement
  10. The DELETE statement

Introduction

Released in January 1998, MySQL is an open source relational database management system (RDBMS). It's based around the Structured Query Language (SQL), and is best for managing the content of the database as opposed to transactions, as MySQL does not support COMMIT or ROLLBACK. One of the biggest drawbacks of MySQL is it's lack of support for referential integrity, no stored procedures, no triggers, and no sub-queries. MySQL is free, and may be downloaded from download section at MySQL.

You might also like...

Comments

About the author

Gez Lemon United Kingdom

I'm available for contract work. Please visit Juicify for details.

Interested in writing for us? Find out more.

MySQL tutorials

MySQL books

  • PHP & MySQL: The Missing Manual

    PHP & MySQL: The Missing Manual

    If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and we...

MySQL forum discussion

MySQL podcasts

  • Stack Overflow Podcast: SE Podcast #22

    Published 7 months ago, running time 0h50m

    Joel (but no Jeff) is joined this week by Paul Biggar (who Joel originally met when he was a DevDays London 2009 speaker about scripting languages).  Paul currently works at Mozilla, having come off his own (not that successful) Y Combinator startup. Paul’s least favorite scripting language of al.

MySQL jobs

MySQL events

  • May 24

    Memphis PHP Meetup

    Memphis, United States

    Monthly meeting and presentation using PHP for web development.

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe