MySQL Crash Course

Action-oriented, project-based self-study guide to the essentials of MySQL.

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.

Introduction

1

(1)

Who Is This Book For?

2

(1)

Companion Website

2

(1)

Conventions Used in This Book

3

(2)

Understanding SQL

5

(8)

Database Basics

5

(6)

What Is SQL?

11

(1)

Try It Yourself

11

(2)

Introducing MySQL

13

(8)

What Is MySQL?

13

(3)

MySQL Tools

16

(5)

Working with MySQL

21

(6)

Making the Connection

21

(1)

Selecting a Database

22

(1)

Learning About Databases and Tables

23

(4)

Retrieving Data

27

(10)

The Select Statement

27

(1)

Retrieving Individual Columns

27

(2)

Retrieving Multiple Columns

29

(2)

Retrieving All Columns

31

(1)

Retrieving Distinct Rows

31

(2)

Limiting Results

33

(2)

Using Fully Qualified Table Names

35

(2)

Sorting Retrieved Data

37

(8)

Sorting Data

37

(2)

Sorting by Multiple Columns

39

(1)

Specifying Sort Direction

40

(5)

Filtering Data

45

(8)

Using the Where Clause

45

(1)

The Where Clause Operators

46

(7)

Advanced Data Filtering

53

(8)

Combining Where Clauses

53

(4)

Using the In Operator

57

(2)

Using the Not Operator

59

(2)

Using Wildcard Filtering

61

(6)

Using the Like Operator

61

(4)

Tips for Using Wildcards

65

(2)

Searching Using Regular Expressions

67

(14)

Understanding Regular Expressions

67

(1)

Using MySQL Regular Expressions

68

(13)

Creating Calculated Fields

81

(8)

Understanding Calculated Fields

81

(1)

Concatenating Fields

82

(4)

Performing Mathematical Calculations

86

(3)

Using Data Manipulation Functions

89

(10)

Understanding Functions

89

(1)

Using Functions

90

(9)

Summarizing Data

99

(12)

Using Aggregate Functions

99

(7)

Aggregates on Distinct Values

106

(2)

Combining Aggregate Functions

108

(3)

Grouping Data

111

(10)

Understanding Data Grouping

111

(1)

Creating Groups

112

(1)

Filtering Groups

113

(3)

Grouping and Sorting

116

(3)

Select Clause Ordering

119

(2)

Working with Subqueries

121

(10)

Understanding Subqueries

121

(1)

Filtering by Subquery

121

(5)

Using Subqueries As Calculated Fields

126

(5)

Joining Tables

131

(12)

Understanding Joins

131

(3)

Creating a Join

134

(9)

Creating Advanced Joins

143

(10)

Using Table Aliases

143

(1)

Using Different Join Types

144

(5)

Using Joins with Aggregate Functions

149

(2)

Using Joins and Join Conditions

151

(2)

Combining Queries

153

(8)

Understanding Combined Queries

153

(1)

Creating Combined Queries

154

(7)

Full-Text Searching

161

(16)

Understanding Full-Text Searching

161

(2)

Using Full-Text Searching

163

(14)

Inserting Data

177

(10)

Understanding Data Insertion

177

(1)

Inserting Complete Rows

177

(4)

Inserting Multiple Rows

181

(2)

Inserting Retrieved Data

183

(4)

Updating and Deleting Data

187

(6)

Updating Data

187

(2)

Deleting Data

189

(1)

Guidelines for Updating and Deleting Data

190

(3)

Creating and Manipulating Tables

193

(14)

Creating Tables

193

(10)

Updating Tables

203

(2)

Deleting Tables

205

(1)

Renaming Tables

205

(2)

Using Views

207

(10)

Understanding Views

207

(3)

Using Views

210

(7)

Working with Stored Procedures

217

(14)

Understanding Stored Procedures

217

(1)

Why Use Stored Procedures

218

(1)

Using Stored Procedures

219

(12)

Using Cursors

231

(10)

Understanding Cursors

231

(1)

Working with Cursors

232

(9)

Using Triggers

241

(8)

Understanding Triggers

241

(1)

Creating Triggers

242

(1)

Dropping Triggers

243

(1)

Using Triggers

244

(5)

Managing Transaction Processing

249

(8)

Understanding Transaction Processing

249

(3)

Controlling Transactions

252

(5)

Globalization and Localization

257

(6)

Understanding Character Sets and Collation Sequences

257

(1)

Working with Character Set and Collation Sequences

258

(5)

Managing Security

263

(10)

Understanding Access Control

263

(1)

Managing Users

264

(9)

Database Maintenance

273

(4)

Backing Up Data

273

(1)

Performing Database Maintenance

274

(1)

Diagnosing Startup Problems

275

(1)

Review Log Files

275

(2)

Improving Performance

277

(4)

Improving Performance

277

(4)

A. Getting Started with MySQL

281

(4)

What You'll Need

281

(1)

Obtaining the Software

282

(1)

Installing the Software

282

(1)

Preparing for Your Chapters

283

(2)

B. The Example Tables

285

(8)

Understanding the Sample Tables

285

(5)

Creating the Sample Tables

290

(3)

C. MySQL Statement Syntax

293

(6)

Alter Table

293

(1)

Commit

294

(1)

Create Index

294

(1)

Create Procedure

294

(1)

Create Table

294

(1)

Create User

295

(1)

Create View

295

(1)

Delete

295

(1)

Drop

295

(1)

Insert

296

(1)

Insert Select

296

(1)

Rollback

296

(1)

Savepoint

296

(1)

Select

297

(1)

Start Transaction

297

(1)

Update

297

(2)

D. MySQL Datatypes

299

(6)

String Datatypes

300

(1)

Numeric Datatypes

301

(2)

Date and Time Datatypes

303

(1)

Binary Datatypes

304

(1)

E. MySQL Reserved Words

305

(4)

Index

309

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Summary

Author Biography

Table of Contents

Supplemental Materials