Support Manual

MySQL References and Tutorials

Books
 

PHP and MySQL Web Development Written by Luke Welling and Linda Thomson Pulbished by Sams; 2nd edition (February 12, 2003) Paperback: 912 pages Dimensions 2.05" x 9.18" x 7.06" ISBN 067232525X Order

From the Back Cover PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. The book teaches the reader to integrate and implement these technologies by following real-world examples and working sample projects, and also covers related technologies needed to build a commercial Web site, such as SSL, shopping carts, and payment systems. The second edition includes new coverage of how to work with XML in developing a PHP and MySQL site, and how to draw on the valuable resources of the PEAR repository of code and extensions.

 

SQL Clearly Explained Written by Randy Jay Yarge, George Reese, and Tim King Pulbished by O'Reilly & Associates ; 1 Ed edition (August 1999) Paperback: 487 pages Dimensions: 1" x 7.5" x 9" ISBN 1565924347 Order

Amazon.com MySQL and mSQL provides the essentials to programming with these two popular Unix freeware database packages in C/C++, Perl, Python, and Java. The book begins with a fine introduction to databases that covers tables, fields, indexes, and normalization. Then it explains the history of the freeware mSQL and MySQL packages (which offer better performance than commercial relational database management system (RDBMS) packages, though they don't support transactions or other features). Next the authors look at SQL as used within MySQL and mSQL and clarify where to download these packages and how to install them. Examples of how to program with MySQL/mSQL in C/C++ follow. One of the best parts of this book is its introduction to using Common Gateway Interface (CGI) and Perl to power a Web site with a MySQL/mSQL database. This section offers complete information on using mSQL Perl (and the emerging Database Independent [DBI] standard) for developing CGI database scripts in Perl, and it includes clear examples (including a student database). The book then moves from Perl on to other programming languages--Python and Java. Reference material to all the relevant APIs is featured for each language. --Richard Dragan

 

The Practical Sql Handbook : Using Structured Query Language Written by Judith S. Bowman Pulbished by Addison-Wesley Pub Co; 4th edition (June 26, 2001) Paperback:512 pages Dimensions: 1.31" x 9.24" x 7.38" ISBN 0201703092 Order

From Book News, Inc. This guide to implementing Structured Query Language introduces basic concepts and offers practical suggestions for its application to business purposes. Instructions are included for the creation of databases, tables, and indexes, with particular attention to the retrieval of specific data, handling null values, and the use of nested queries and multiple tables. An accompanying CD-ROM contains sample databases, scripts, and examples from the book, in addition to a time-limited version of Sybase Adaptive Server Anywhere software.Book News, Inc.®, Portland, OR

 

 

SQL Clearly Explained Written by Jan L. Harrington Pulbished Morgan Kaufmann Publishers Paperback:304 pages Dimensions 0.73" x 9.23" x 7.40" SBN 012326426X Order

From Book News, Inc. SQL is a computer language designed to manipulate relational databases. This introduction defines syntax, explains how SQL works, and covers proper structure of queries, how to produce a desired result and minimize burden on command processors, and how to modify data and database structure for ease of use and increased efficiency. The sample database used for examples is available on the author's web site. Book News, Inc.®, Portland, OR Book Description If you're working with an enterprise DBMS, then you're probably using SQL, the standard query language for relational databases. Like most computer languages, SQL can be overwhelming when you first see it. The book you are holding will help you wipe away the confusion so that you understand SQL and how it works.

 

 

Web Sites

The MySQL site has an SQL reference and lots of information about MySQL in particular.

An SQL tutorial is available on the net at http://www.geocities.com/SiliconValley/Vista/2207/sql1.html

Mailing Lists

The MySQL site lists in their documentation page a number of mailing lists concerning MySQL and SQL.

 

Overview 

MySQL Control Panel Feature

Examples of SQL Statements 

 Quick Actions

Advanced Queries

Table Properties

Table Select 
Perl While Loop Example
Using MySQL With CGI Scripts
References and Tutorials

 

 

Copyright © 2003-2007 Hosting Connecticut, LLC.
Resellers of Hosting Connecticut, LLC. may reproduce this manual on their sites.