Managing & Using MySQL and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading Managing & Using MySQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites [Paperback]

Tim King , George Reese , Randy Yarger , Hugh E. Williams
3.1 out of 5 stars  See all reviews (13 customer reviews)
List Price: CDN$ 45.99
Price: CDN$ 26.30 & FREE Shipping. Details
You Save: CDN$ 19.69 (43%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 2 to 4 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition CDN $18.89  
Paperback CDN $26.30  

Book Description

May 3 2002 0596002114 978-0596002114 Second Edition

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 throughout.

This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions.

If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language.

Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.


Customers Who Bought This Item Also Bought


Product Details


Product Description

From Amazon

Managing and Using MySQL describes the installation, administration and programming of this hugely popular open source database manager. The main focus is on using MySQL in Web applications hosted on Linux or Unix. The book is based on MySQL 3.23. It’s aimed at programmers, but database design and the SQL language are explained from scratch, so it’s also suitable for Web developers who are beginners when it comes to databases.

The scene is set with a brief history of MySQL, explaining its position as a fast and generally free alternative to the fuller-featured commercial heavyweights like Oracle or DB2. Next comes an introduction to SQL, followed by three chapters on administration, covering configuration, data recovery, tuning, security and user management. There's a brief look at database design too. That accounts for around one third of the book. The rest is about programming with chapters on using MySQL from Perl, Python, PHP and Java, and a look at how to extend MySQL with user-defined functions written in C. The last part of the book is a reference section, covering SQL syntax and functions, along with the MySQL API in PHP, C, and Python.

This is an excellent book for getting started with MySQL as well as a convenient reference. It has a broad scope, which means it does not go deeply into the various topics. For example, those using PHP might be better off with a more specialist title like Web Database Applications with PHP and MySQL. On the other hand, Managing and Using MySQL is ideal for a general and highly accessible overview of what MySQL can do.--Tim Anderson

From the Publisher

Learn how to use MySQL, a popular database product that supports key subsets of SQL on Linux and Unix systems. Using C/C++, Java, Perl, PHP, or Python, you can write programs to interact with a MySQL database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and database administration. It includes ample tutorial material and examples.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

Most helpful customer reviews
2.0 out of 5 stars Lack of In-Depth Information June 27 2004
By A Customer
Format:Paperback
I generally love the O'Reilly books because they tend to be very thorough and have lots of practical code examples, but this book was a big disappointment to me. I was easily frustrated by this book. As a beginner to MySQL and database programming, I was completely lost whenever I tried to apply something to my own projects. The explanations given here are very brief and the authors often send you elsewhere for more in-depth discussion. I wound up doing most of my research online and just using the SQL reference chapter to look-up query syntax. I give it two stars because it did help me get started, but I'd say this is a poor reference for anyone looking for in-depth coverage.
Was this review helpful to you?
4.0 out of 5 stars Getts you going Jan. 29 2004
Format:Paperback
Great book to get you up and running with MySQL.
Thanks O'Reilly...
Was this review helpful to you?
Format:Paperback
This book is clearly and succinctly written, and provides an excellent introduction to MySQL. It starts with a few pages on the history and philosophy behind MySQL, which is useful if you want to understand the advantages and disadvantages of MySQL relative to other options such as PostgreSQL or Oracle. It then follows with chapters on installation, with specific instructions for Solaris, Linux, and Windows; on MySQL's dialect of SQL (Structured Query Language); and on basic administration tasks such as configuration, startup and shutdown, logging, backup, and recovery. That's really all you need to get a basic database up and running, and it's all in the first 80 pages of the book.
Part II of the book covers more advanced administrative tasks, with chapters on performance tuning, security, and database design. This section of the book is weaker than the first section; while there's some useful introductory material on each of these topics, depth is lacking. For example, the discussion of putting a database into second normal form is misleading because it uses a table with only one field as the unique identifier, making it impossible to clearly illustrate the removal to a smaller table of fields that are dependent on only part of a (typically multifield) unique identifier. Also, some of the more advanced MySQL features which might be appropriate for this section are omitted.
Part III of the book, entitled "MySQL Programming", has sections accessing MySQL from Perl, Python, PHP, C, Java. These sections are mostly limited to information specific to MySQL that might not be found in general purpose documentation of these languages.
Read more ›
Was this review helpful to you?
1.0 out of 5 stars Don't waste your money Nov. 4 2003
Format:Paperback
this is a typical book comes out of George Reese:
1. poorly written
2. shamelessly copy and paste existing materials from reference manual
3. full of error
the author is only trying to get a quick buck or two.avoid it at all cost.
Was this review helpful to you?
1.0 out of 5 stars Not very useful, no "Managing" covered Oct. 14 2003
Format:Paperback
I bought this book as a reference when I was migrating from SQL Server to MySQL. I was hoping to learn from this book some of the language implementations and how to administer on-line databases (backups, benchmarking, security). I found this book to be very lacking. The book provides very little of the language references of SQL, and devotes the majority of the text to function call references for C, Perl/DBI, PHP and Python. (I would think if you were looking for mysql function calls for these languages you would use the specific language reference). If you don't develop front-ends to MySQL in these languages (but still want to "Manage and Use MySQL") then the bulk of this book is probably useless to you.
As for managing MySQL, this text provides very little practical information. Sure it covers the GRANT statements, but doesn't go into much depth. For example, I found very little information about archiving or trying to incorporate some type of pseudo-replication.
In general, I notice that my book is still in fairly new condition, and doesn't get used much ... it is just an arm's reach away. I use the FREE online MySQL manual almost everyday. That should tell you something right there, huh.
Was this review helpful to you?
4.0 out of 5 stars Initialisation file lacking Aug. 30 2003
Format:Paperback
The book helps one to program for MYSQL in C, or other languages for that matter, but the installation section does not describe how to set up the "my.ini" file. It does a good job on the SQL syntax used by MySQL.
Was this review helpful to you?
5.0 out of 5 stars A good reference book Feb. 26 2003
By A Customer
Format:Paperback
The security chapter is well written and the reference section is comprehensive.
Was this review helpful to you?
Want to see more reviews on this item?
Most recent customer reviews
5.0 out of 5 stars Excellent Reference But Not Much On Managment
This book is an excellent reference book for MySQL. In fact I'd rate it the best MySQL reference out there when using MySQL as a coder. Read more
Published on Sept. 17 2002 by J. Whittenburg
3.0 out of 5 stars A good book covering a lot of topics
The title is not all together indicative of what the authors try to accomplish in this book. The book attempts to be both a tutorial and a reference for programmers and... Read more
Published on Sept. 9 2002 by C. M. Lowry
1.0 out of 5 stars It is NOT for managing MySQL
The book title is completely mis-leading. It has little info on administrate the server - little practical details. Read more
Published on Aug. 22 2002 by Jack W. Wang
3.0 out of 5 stars Not the best thing in the world..
If you are buying this book to learn how to manage MYSQL look on.. There is maybe one chapter on server mgt.. and 20 on programming for mysql.
The server mgt. Read more
Published on July 18 2002 by Jeremy Loukinas
5.0 out of 5 stars A great reference
This book contains everything you will need to know about MySQL. As a MySQL DBA and developer, every time I've needed to look something up I've found it in this book. Read more
Published on July 4 2002
2.0 out of 5 stars Better than the 1st edition
This book is a significant improvement over the 1st edition (which was titled MySQL & mSQL), mainly because it focuses directly on MySQL instead of focusing on the differences... Read more
Published on June 23 2002 by G. Keefe
Search Customer Reviews
Only search this product's reviews
ARRAY(0xab66bcd8)

Look for similar items by category


Feedback