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:
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.
IntroductionIntroduction
MySQL has become one of the most popular database management systems in the world. From small development projects to some of the best-known and most prestigious sites on the Web, MySQL has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data storage needs.
This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes. That book has become one of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to know—methodically, systematically, and simply. But as popular and as successful as that book is, it does have some limitations:
And that is where this book comes in. MySQL Crash Course builds on the proven tutorials and structure of Sams Teach Yourself SQL in 10 Minutes, without getting bogged down with anything but MySQL. Starting with simple data retrieval and working on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more. You'll learn what you need to know methodically, systematically, and simply—in highly focused chapters designed to make you immediately and effortlessly productive.
So turn to Chapter 1, and get to work. You'll be taking advantage of all MySQL has to offer in no time at all.
Who Is This Book For?
This book is for you if
This book has a companion website online at http://forta.com/books/0672327120/. Visit the site to access
This book uses different typefaces to differentiate between code and regular English, and also to help you identify important concepts.
Text that you type and text that should appear on your screen is presented in monospace type. It looks like this to mimic the way text looks on your screen.
Placeholders for variables and expressions appear in monospace italic font. You should replace the placeholder with the specific value it represents.
This arrow (¬) at the beginning of a line of code means that a single line of code is too long to fit on the printed page. Continue typing all the characters after the ¬ as though they were part of the preceding line.
Note - A Note presents interesting pieces of information related to the surrounding discussion.
Tip - A Tip offers advice or teaches an easier way to do something.
Caution - A Caution advises you about potential problems and helps you steer clear of disaster.
Note - A New Term box provide clear definitions of new, essential terms.
/Input
The Input icon identifies code that you can type in yourself. It usually appears next to a listing.
/Output
The Output icon highlights the output produced by running MySQL code. It usually appears after a listing.
/Analysis
The Analysis icon alerts you to the author's line-by-line analysis of input or output.
© Copyright Pearson Education. All rights reserved.
MySQL¨Crash Course
Sequences .............................................................................................. 257
Sequences .............................................................................................. 258
MySQL has become one of the most popular database management systems in the world. From small development projects to some of the best-known and most prestigious sites on the Web, MySQL has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data storage needs.
This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes. That book has become one of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to know—methodically, systematically, and simply. But as popular and as successful as that book is, it does have some limitations:
And that is where this book comes in. MySQL Crash Course builds on the proven tutorials and structure of Sams Teach Yourself SQL in 10 Minutes, without getting bogged down with anything but MySQL. Starting with simple data retrieval and working on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more. You'll learn what you need to know methodically, systematically, and simply—in highly focused chapters designed to make you immediately and effortlessly productive.
So turn to Chapter 1, and get to work. You'll be taking advantage of all MySQL has to offer in no time at all.
This book is for you if
This book has a companion website online at http://forta.com/books/0672327120/. Visit the site to access
This book uses different typefaces to differentiate between code and regular English, and also to help you identify important concepts.
Text that you type and text that should appear on your screen is presented in monospace type. It looks like this to mimic the way text looks on your screen.
Placeholders for variables and expressions appear in monospace italic font. You should replace the placeholder with the specific value it represents.
This arrow (¬) at the beginning of a line of code means that a single line of code is too long to fit on the printed page. Continue typing all the characters after the ¬ as though they were part of the preceding line.
Note - A Note presents interesting pieces of information related to the surrounding discussion.
Tip - A Tip offers advice or teaches an easier way to do something.
Caution - A Caution advises you about potential problems and helps you steer clear of disaster.
Note - A New Term box provide clear definitions of new, essential terms.
/Input
The Input icon identifies code that you can type in yourself. It usually appears next to a listing.
/Output
The Output icon highlights the output produced by running MySQL code. It usually appears after a listing.
/Analysis
The Analysis icon alerts you to the author's line-by-line analysis of input or output.
© Copyright Pearson Education. All rights reserved.
Overview
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 ...