• Complain

King Tim - Managing and using MySQL

Here you can read online King Tim - Managing and using MySQL full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. City: Beijing, year: 2002;2009, publisher: OReilly Media, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

King Tim Managing and using MySQL

Managing and using MySQL: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Managing and using MySQL" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Pt. I. Introduction. 1. MySQL. 2. Installation. 3. SQL According to MySQL. 4. Database Administration -- Pt. II. MySQL Administration. 5. Performance Tuning. 6. Security. 7. Database Design -- Pt. III. MySQL Programming. 8. Database Applications. 9. Perl. 10. Python. 11. PHP. 12. CAPI. 13. Java. 14. Extending MySQL -- Pt. IV. MySQL Reference. 15. SQL Syntax for MySQL. 16. MySQL Data Types. 17. Operators and Functions. 18. MySQL PHP API Reference. 19. C Reference. 20. The Python DB-API.;MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included thro.

King Tim: author's other books


Who wrote Managing and using MySQL? Find out the surname, the name of the author of the book and a list of all author's works by series.

Managing and using MySQL — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Managing and using MySQL" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Managing and Using MySQL, 2nd Edition
Tim King
George Reese
Randy Yarger
Hugh E. Williams
Editor
Andy Oram

Copyright 2009 O'Reilly Media, Inc.

OReilly Media SPECIAL OFFER Upgrade this ebook with OReilly for more - photo 1

O'Reilly Media

SPECIAL OFFER: Upgrade this ebook with OReilly

for more information on this offer!

Please note that upgrade offers are not available from sample content.

A Note Regarding Supplemental Files

Supplemental files and examples for this book can be found at http://examples.oreilly.com/9780596002114/. Please use a standard desktop web browser to access these files, as they may not be accessible from all ereader devices.

All code files or examples referenced in the book will be available online. For physical books that ship with an accompanying disc, whenever possible, weve posted all CD/DVD content. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to .

Preface

Programmers have always put together software on their own time to"scratch their own itches." Untilthe 1990s, however, programmers lacked distribution mediums for massmarketing their creations. The Internet changed that and gave life tograss-roots software distribution philosophies that have challengedthose of the software giants. These philosophies include the FreeSoftware and Open Software movements.

Though significant differences cause endless debate between the FreeSoftware and Open Software camps, they share a core belief in thefreedom to access and modify the source code of any legally licensedsoftware. Though neither philosophy revolves directly around price,both have had the ultimate effect of reducing the cost of sometraditionally high-cost software. The most famous example of thiseffect is, of course, the Linux operating system.

Database software has always been notoriously overpriced. The entirefortune of Oracle is largely founded on a single producttheOracle database engine. Consequently, only large corporations havehad the financial resources to leverage the power of relationaldatabases. While database vendors struggled with how to license theirsoftware on the Internet, however, several groups of people were busydeveloping free and low-cost database solutions based on Free andOpen Software philosophies. Our focus is one of these databases:MySQL.

MySQL is powerful and flexible, while at the same time lightweightand efficient. It packs a large feature set into a very small, fastengine. While it does not have anywhere near the full feature set ofexpensive corporate databases, it easily offers enough to meet theneeds of mid-range database management.

Audience

This book is primarily for two classes of readers. The most obviousis the reader interested in using MySQL from either a databaseadministration perspective or from a database programmer perspective.In addition, anyone who wants to learn about relational databaseadministration and programming without paying out the nose for alicense from one of the big guys will find MySQL an excellentstarting point.

From a database administrator's perspective, wecover the basic methods of creating and managing databases and tablesin MySQL. We go beyond the simple tasks and provide performancetuning and troubleshooting tips to help you make sure your MySQLapplications are running at their best. We assume no prior knowledgeof SQL or relational databases.

Database programmers will find that we have covered all the majorprogramming interfaces from the most popular client/server and webprogramming languages. When we cover the interface for a particularlanguage, we assume the reader has a basic grasp of the language inquestion. For example, in theJava chapter, we assumethe reader knows how to write basic Java applications, and we showhow to make those Java applications talk to MySQL databases.

The immense popularity of MySQL on the Web has made it natural toprovide a focus on CGI programming with Managing and UsingMySQL . Web developers should therefore find this bookuseful in describing how to drive their web sites with a MySQLdatabase. For these chapters, very little CGI knowledge is needed,but we still assume that the reader is familiar with the basics ofthe programming language in question.

Purpose

At first glance, the purpose of this book seems obvious: MySQL is oneof the most popular open source applications of all time. One of thebiggest complaints about open source projects is the lack ofcomprehensive and comprehensible documentation. In the case of MySQL,however, lack of online documentation is rarely a problem.

MySQL has a wonderfully complete and free online reference manualavailable from the web site, at http://www.mysql.com. This manual covers thefull MySQL SQL syntax, installation, and its C API, as well asdatabase administration and performance tuning.

To make matters even more complex, MySQL is a moving target becauseof rapid development. In fact, "movingtarget" is a euphemism. Thanks mainly to the effortsof Michael "Monty" Widenius, MySQLis moving about as fast as an SST. So be prepared; you may find thatsome of the information in this book is either ahead of olderversions or behind newer versions.

Using This Book

We have divided this book into four sections. , we provide a reference section as a resourcefor quickly looking up APIs we cover in the first three sections.

if you are an experienced MySQL user orsimply skim it if you have experience with other database engines.

The job of the database administrator is to make certain that thedatabase is up and running efficiently and supporting itsapplications. If this is your job, isfor you. We cover security, performance tuning, and database design.Proper database design is essential for database architects if thegoal is to build database applications flexible enough to scale astheir needs change. You also need a proper database design if youwant your database to actually perform well.

is aimed at database architects andprogrammers. It contains chapters devoted to programming in specificlanguages or using specific tools. Of particular interest to webprogrammers will be the chapters on Perl, Java, Python, and PHP.

The book closes with a reference section covering elements of MySQLand some APIs.

Conventions Used in This Book

The following conventions are used in this book:

Constant width

Used to indicate anything that might appear in a program, includingkeywords, function names, SQL commands, and variable names. This fontis also used for code examples, output displayed by commands, andsystem configuration files.

Constant width bold

Used to indicate user input.

Constant width italic

Used to indicate an element (e.g., a filename or variable) that yousupply.

Italic

Used to indicate directory names, filenames, program names, Unixcommands, and URLs. This font is also used to introduce new terms andfor emphasis.

Note

This icon is used to indicate a tip, suggestion, or general note.

Warning

This icon is used to indicate a warning.

Comments and Questions

Please address comments and questions concerning this book to thepublisher:

O'Reilly & Associates, Inc.
Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Managing and using MySQL»

Look at similar books to Managing and using MySQL. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Managing and using MySQL»

Discussion, reviews of the book Managing and using MySQL and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.