MySQL Crash Course

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

• Retrieve and sort data
• Filter data using comparisons, regular expressions, full text search, and much more
• Join relational data
• Create and alter tables
• Insert, update, and delete data
• Leverage the power of stored procedures and triggers
• Use views and Cursors
• Manage transactional processing
• Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken MySQL Crash Course - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Ben Forta is Macromedia Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and its sequel Advanced ColdFusion 4 Application Development. His book Sams Teach Yourself SQL in 10 Minutes is one of the world's bestselling SQL books with over 100,000 copies sold.

(Computer Bookshops Limited)

MySQLCrash Course

Table of Contents

Introduction                                                                   1

Who Is This Book For? ................................................................................. 2

Companion Website ...................................................................................... 2

Conventions Used in This Book ................................................................. 3

1  Understanding SQL                                                        5

Database Basics ............................................................................................. 5

What Is SQL? ............................................................................................... 11

Try It Yourself ............................................................................................... 11

2  Introducing MySQL                                                       13

What Is MySQL? ......................................................................................... 13

MySQL Tools ............................................................................................... 16

3  Working with MySQL                                                   21

Making the Connection .............................................................................. 21

Selecting a Database .................................................................................. 22

Learning About Databases and Tables .................................................. 23

4  Retrieving Data                                     &nbs...

(Computer Bookshops Limited)