Release Team[oR] 2001 [x] Database - CGI, Java, MySQL ...

1 Release Team[oR] 2001 [x] Database - 2 - Sam's Teach Yourself MySQL in 21 Days by Mark Maslakowski ISBN: 0672319144 Sams 2000, 532 pages A complete course in using one of the most-popular open source databases. Table of Contents Colleague Comments Back Cover Synopsis by Stan Miastkowski For those who need a full-powered relational DBMS without the considerable expense of well-known commercial products (such as Microsoft SQL Server), MySQL has quickly become a favorite. This open source Database is available for virtually all platforms, including the various incarnations of Windows.

2 But like many open source products, its documentation is sparse. Enter Teach Yourself MySQL in 21 Days, a book that solves the documentation dearth problem with an effective and accessible step-by-step course in the DBMS. No prior SQL experience is assumed so even beginners will benefit from this book. Table of Contents Sams Teach Yourself MySQL in 21 Days - 3 Introduction - 5 Week 1 At a Glance Day 1 - What Is MySQL ? - 9 Day 2 - Getting Started - 13 Day 3 - Designing Your First Database - 21 Day 4 - Creating Your First Database - 32 Day 5 - Making Your Data Normal - 38 Day 6 - Adding Tables, Columns.

3 And Indexes to Your Database - 43 Day 7 - MySQL Data Types - 50 Week 2 At a Glance Day 8 - Populating the Database - 58 Day 9 - Querying the Database - 71 Day 10 - Letting MySQL Do the Work Intrinsic Functions - 85 Day 11 - MySQL Table Locks and Assorted Keys - 93 Day 12 - How to Get the Data Database Interfaces - 107 Day 13 - How to Use MyODBC - 111 Day 14 - The Perl Database Interface - 139 Week 3 At a Glance Day 15 - MySQL and PHP - 156 - 3 - Day 16 - MySQL and Time - 171 Day 17 - MySQL Database Security - 185 Day 18 - How MySQL Compares - 195 Day 19 - Administrating MySQL - 204 Day 20 - Optimizing MySQL - 219 Day 21 - Putting It All Together - 225 Appendix A - ASQL Syntax and Commands - 271 Appendix B - Current MySQL Functions - 278 Appendix C - Answers to Exercises - 298 List of Figures List of Tables List of Listings List of Sidebars Back Cover In just 21 days.

4 You'll have all the skills you need to get up and running efficiently. With this complete tutorial, you'll master the basics and then move on to the more advanced features and concepts. Understand the fundamentals and master all of the key features of MySQL Learn how to effectively use the latest tools and features of MySQL by following practical, real-world examples Get expert tips from a leading authority on implementing MySQL in the corporate environment This book is designed for the way you learn. Go through the lessons day by day or just chose those lessons that interest you the most.

5 Build robust databases from the ground up Access data easily and efficiently using Database interfaces Optimize MySQL and keep your databases secure Design efficient MySQL databases using normalization Learn how to define business rules and objects Protect access with Table Locks and Keys Make the best use of MySQL 's intrinsic fuctions such as numerical operations, string manipulations, and logical conditions. About the Author Mark Maslakowski is a consultant working for Thor Systems Inc.

6 , a company specializing in systems integration. As a Senior Solution Developer. Mark has designed and created computer-based solutions for several national and international corporations on a diverse set of platforms. Originally a Windows developer who used Visual Basic and Visual C++, Mark has joined the open source revolutions and prefers using programming languages such as Perl and Tcl/Tk. Sams Teach Yourself MySQL in 21 Days Mark Maslakowski Tony Butcher Copyright 2000 by Sams - 4 -All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher.

7 No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions. Neither is any liability assumed for damages resulting from the use of the information contained herein. International Standard Book Number: 0-672-31914-4 Library of Congress Catalog Card Number: 99-69680 Printed in the United States of America First Printing: June, 2000 Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized.

8 Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark. Warning and Disclaimer Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an "as is" basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the CD or programs accompanying it.

9 Associate Publisher Michael Stephens Executive Editor Rosemarie Graham Acquisitions Editor Shelley Johnston Development Editor Clint McCarty Gus A. Miklos Managing Editor Matt Purcell Project Editor Andy Beaster Copy Editor Pat Kinyon Indexer Sandy Henselmeier Proofreader Matt Wynalda Technical Editor Pierre Boutquin Team Coordinator Pamalee Nelson Software Development Specialist Jason Haines Interior Design Gary Adair Cover Design Aren Howell Copy Writer Eric Borgert Production Brandon Allen Cheryl Lynch About the Authors Mark Maslakowski is a consultant working for Thor Systems Inc.

10 , a company specializing in systems integration. As Senior Solutions Developer, Mark is responsible for developing solutions that fit clients' needs, no matter what the platform. He has been involved in developing large multi-tier applications for - 5 -several major corporations. Mark started his career in the Army and has been on the move since. He has filled of many roles, including Database Administrator, Senior Developer, and Senior Systems Analyst. Mark can be reached at Tony Butcher is a consultant specializing in the design of interactive and Database -driven Web sites.