Copyright ©1998-2010 Glenn Fleishman. Send in your comments. Bibliographic information on isbn.nu licensed from Baker & Taylor. Contact them for corrections and licensing, or read more about our data.
Tables of Contents for Sams Teach Yourself Mysql in 24 Hours
Chapter/Section Title
Page #
Page Count
Introduction
1
4
Part I Introduction to MySQL and Relational Databases
5
32
Introducing MySQL
7
10
Understanding Database Terminology
17
8
Learning the Database Design Process
25
12
Part II Setting Up Your Environment
37
26
Using the MySQL Client
39
14
Securing MySQL
53
10
Part III Learning to Plan for Your Database-Driven Applications
63
32
Planning and Creating Your Database
65
8
Creating Your Database Tables-Part I
73
10
Creating Your Database Tables-Part II
83
12
Part IV Working with Your Tables
95
72
Populating Your Database Tables
97
14
Selecting Data from Your Tables
111
14
Advanced Usage of SELECT Statements
125
10
Modifying and Deleting Data
135
12
More About DELETE
147
10
Modifying Table Structure
157
10
Part V Using Built-in Functions in MySQL Queries
167
40
Using MySQL String Functions
169
12
Using MySQL Numeric Functions
181
12
Using MySQL Date and Time Functions
193
14
Part VI Using Transactions
207
18
Transactions Overview
209
8
Practical Transaction Usage
217
8
Part VII Administering Your MySQL Server
225
32
Optimizing and Tuning Your Database
227
10
Backing Up and Restoring Your Database
237
8
Basic Administrative Commands
245
12
Part VIII Interfacing with MySQL
257
30
Using MySQL with Perl
259
12
Using MySQL with PHP
271
16
Part IX Appendices
287
52
A Installing MySQL
289
9
B Using MyODBC
298
13
C Reserved Words
311
4
D Practical MySQL/PHP Examples
315
24
Index
339