MySQL, Second Edition Visual QuickStart Guide

Task-based guide covers everything about using and administrating the world's most popular open-source database application!

Larry Ullman is the Director of Digital Media Technology at DMC Insights, Inc., a firm specializing in information technology. He is the author of several books on PHP, MySQL, and Web development, including PHP for the World Wide Web: Visual QuickStart Guide (1st and 2nd editions). In addition to writing, he develops dynamic Web applications (in PHP and ASP.NET), conducts training seminars (on PHP, Oracle, and SQL), and teaches at the University of California Berkeley Extension Online.

Introduction

ix

Chapter 1: Installing MySQL

1

(22)

General Installation Steps

2

(3)

Installing MySQL on Windows

5

(3)

Configuring MySQL on Windows

8

(2)

Installing MySQL on Macintosh

10

(3)

Installing MySQL on Linux

13

(5)

Basic Configuration Options

18

(3)

Upgrading MySQL

21

(2)

Chapter 2: Running MySQL

23

(34)

Running MySQL on Windows and Windows NT

24

(9)

Running MySQL on Mac OS X

33

(3)

Running MySQL on Linux and Unix

36

(3)

Using mysqladmin

39

(3)

Setting the Root User Password

42

(2)

Using the mysql Client

44

(4)

Users and Privileges

48

(9)

Chapter 3: Database Design

57

(14)

Normalization

58

(1)

Understanding Keys

59

(2)

Understanding Relationships

61

(2)

First. Normal Form

63

(2)

Second Normal Form

65

(3)

Third Normal Form

68

(3)

Chapter 4: Creating a MySQL Database

71

(30)

MySQL Data Types

72

(5)

Extra Column Characteristics

77

(3)

Introduction to Indexes

80

(2)

Finalizing Table's Design

82

(3)

Choosing a Storage Engine

85

(3)

Character Sets and Collations

88

(3)

Creating Databases

91

(2)

Creating Tables

93

(5)

Modifying Tables

98

(3)

Chapter 5: Basic SQL

101

(32)

Using Values in Queries

102

(2)

Inserting Data

104

(4)

Selecting Data

108

(3)

Using Conditionals

111

(3)

Using LIKE and NOT LIKE

114

(3)

Performing Joins

117

(6)

Sorting Query Results

123

(2)

Limiting Query Results

125

(2)

Updating Data

127

(2)

Deleting Data

129

(4)

Chapter 6: MySQL Functions

133

(28)

Text Functions

134

(3)

Concatenation and Aliases

137

(5)

Numeric Functions

142

(3)

Date and Time Functions

145

(4)

Formatting the Date and Time

149

(2)

Encryption Functions

151

(3)

Grouping Functions

154

(3)

Other Functions

157

(4)

Chapter 7: MySQL and PHP

161

(44)

Connecting to MySQL and Selecting a Database

162

(4)

Executing Simple Queries

166

(8)

Retrieving Query Results

174

(8)

Using mysqli_insertid()

182

(7)

Error Handling

189

(3)

Security Considerations

192

(13)

Chapter 8: MySQL and Perl

205

(38)

Installing Perl with MySQL Support on Windows

206

(3)

Installing Perl Support for MySQL on Unix and Mac OS X

209

(2)

Testing Perl and MySQL

211

(4)

Connecting to MySQL

215

(3)

Retrieving Query Results

218

(4)

Executing Simple Queries

222

(5)

Retrieving the Insert ID

227

(3)

Error Handling

230

(4)

Security Considerations

234

(3)

Using Prepared Statements

237

(6)

Chapter 9: MySQL and Java

243

(36)

Installing Java Support for MySQL

244

(3)

Connecting to the Database

247

(7)

Executing Simple Queries

254

(7)

Retrieving Query Results

261

(7)

Retrieving the Insert ID

268

(6)

Using Prepared Statements

274

(5)

Chapter 10: Advanced SQL and MySQL

279

(30)

Performing Transactions

280

(7)

Full-Text Searching

287

(10)

Regular Expressions

297

(3)

User-Defined Variables

300

(3)

Introducing Unions

303

(6)

Chapter 11: MySQL 5 Features

309

(36)

Stored Routines

310

(20)

Using OUT Parameters

330

(3)

Triggers

333

(5)

Views

338

(7)

Chapter 12: Techniques for Programming

345

(42)

Storing and Retrieving Binary Data

346

(18)

Making Query Result Pages

364

(14)

Using Transactions with Perl

378

(9)

Chapter 13: MySQL Administration

387

(26)

The MySQL Administrator

388

(4)

Backing Up Databases

392

(4)

Importing Data

396

(2)

MySQL Logging

398

(3)

Database Maintenance

401

(4)

Improving Performance

405

(4)

Using Batch Files

409

(4)

Appendix A: Troubleshooting

413

(12)

Installation

414

(1)

Starting MySQL

415

(1)

Accessing MySQL

416

(2)

mysql.sock Problems

418

(2)

Queries That Return Strange Results

420

(1)

Authentication Protocol Problems

421

(1)

Resetting the Root Password

422

(3)

Appendix B: SQL and MySQL References

425

(14)

Basic SQL

426

(2)

ALTER Commands

428

(1)

SQL Clauses

429

(1)

MySQL Privileges

430

(1)

MySQL Data Types

431

(2)

MySQL Functions

433

(4)

Other References

437

(2)

Appendix C: Resources

439

(10)

MySQL-Specific

440

(2)

Third-Party MySQL Applications

442

(1)

SQL

443

(1)

PHP

444

(1)

Perl

445

(1)

Java

446

(1)

Other

447

(2)

Index

449

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!

MySQL, Second Edition Visual QuickStart Guide

Summary

Author Biography

Table of Contents

Supplemental Materials