MySQL crash course Includes index

✍ Scribed by Forta, Ben

• Publisher: Sams Publishing
• Year: 2005
• Tongue: English
• Leaves: 336
• Series: Safari Books Online;Sams Teach Yourself in 10 Minutes
• Category: Library

✦ Synopsis

Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't.MySQL Crash Courseis a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to: Use the MySQL toolset Retrieve and sort data Filter data using comparisons, wildcards, and full text searching Use the aggregate functions to analyze data Perform insert, update, and delete operations Join relational tables using inner, outer, and self joins Combine queries using unions Use views Create, and modify tables, and access table schemas Create and use stored procedures, cursors, and other advanced database features Manage databases, users, and security privileges

✦ Table of Contents

Cover......Page 1
Contents......Page 6
Introduction......Page 16
Companion Website......Page 17
Conventions Used in This Book......Page 18
Database Basics......Page 20
Try It Yourself......Page 26
What Is MySQL?......Page 28
MySQL Tools......Page 31
Making the Connection......Page 36
Selecting a Database......Page 37
Learning About Databases and Tables......Page 38
Retrieving Individual Columns......Page 42
Retrieving Multiple Columns......Page 44
Retrieving Distinct Rows......Page 46
Limiting Results......Page 48
Using Fully Qualified Table Names......Page 50
Sorting Data......Page 52
Sorting by Multiple Columns......Page 54
Specifying Sort Direction......Page 55
Using the WHERE Clause......Page 60
The WHERE Clause Operators......Page 61
Combining WHERE Clauses......Page 68
Using the IN Operator......Page 72
Using the NOT Operator......Page 74
Using the LIKE Operator......Page 76
Tips for Using Wildcards......Page 80
Understanding Regular Expressions......Page 82
Using MySQL Regular Expressions......Page 83
Understanding Calculated Fields......Page 96
Concatenating Fields......Page 97
Performing Mathematical Calculations......Page 101
Understanding Functions......Page 104
Using Functions......Page 105
Using Aggregate Functions......Page 114
Aggregates on Distinct Values......Page 121
Combining Aggregate Functions......Page 123
Understanding Data Grouping......Page 126
Creating Groups......Page 127
Filtering Groups......Page 128
Grouping and Sorting......Page 131
SELECT Clause Ordering......Page 134
Filtering by Subquery......Page 136
Using Subqueries As Calculated Fields......Page 141
Understanding Joins......Page 146
Creating a Join......Page 149
Using Table Aliases......Page 158
Using Different Join Types......Page 159
Using Joins with Aggregate Functions......Page 164
Using Joins and Join Conditions......Page 166
Understanding Combined Queries......Page 168
Creating Combined Queries......Page 169
Understanding Full-Text Searching......Page 176
Using Full-Text Searching......Page 178
Inserting Complete Rows......Page 192
Inserting Multiple Rows......Page 196
Inserting Retrieved Data......Page 198
Updating Data......Page 202
Deleting Data......Page 204
Guidelines for Updating and Deleting Data......Page 205
Creating Tables......Page 208
Updating Tables......Page 218
Renaming Tables......Page 220
Understanding Views......Page 222
Using Views......Page 225
Understanding Stored Procedures......Page 232
Why Use Stored Procedures......Page 233
Using Stored Procedures......Page 234
Understanding Cursors......Page 246
Working with Cursors......Page 247
Understanding Triggers......Page 256
Creating Triggers......Page 257
Dropping Triggers......Page 258
Using Triggers......Page 259
Understanding Transaction Processing......Page 264
Controlling Transactions......Page 267
Understanding Character Sets and Collation Sequences......Page 272
Working with Character Set and Collation Sequences......Page 273
Understanding Access Control......Page 278
Managing Users......Page 279
Backing Up Data......Page 288
Performing Database Maintenance......Page 289
Review Log Files......Page 290
Improving Performance......Page 292
What You’ll Need......Page 296
Installing the Software......Page 297
Preparing for Your Chapters......Page 298
Understanding the Sample Tables......Page 300
Creating the Sample Tables......Page 305
ALTER TABLE......Page 308
CREATE TABLE......Page 309
DROP......Page 310
SAVEPOINT......Page 311
UPDATE......Page 312
D: MySQL Datatypes......Page 314
String Datatypes......Page 315
Numeric Datatypes......Page 316
Date and Time Datatypes......Page 318
Binary Datatypes......Page 319
E: MySQL Reserved Words......Page 320
A......Page 324
B-C......Page 325
E-F......Page 327
G-H-I......Page 328
M......Page 329
O......Page 330
R......Page 331
S......Page 332
T......Page 333
V-W-X-Y-Z......Page 334

✦ Subjects

Reference;Computer Science;Computers;Programming;Nonfiction;Science;Technology