- You'll save an extra 5% on Books purchased from Amazon.ca, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)
Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites Paperback – May 3 2002
|New from||Used from|
Special Offers and Product Promotions
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
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. Its aimed at programmers, but database design and the SQL language are explained from scratch, so its 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.See all Product Description
Top Customer Reviews
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 ›
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.
The authors do not assume that the reader is knowledgeable about relational databases in general, SQL, or the related topics. For example, the chapter on SQL on MySQL does not just describe the subset of SQL-92 that MySQL supports, but rather it contains a tutorial on the SQL for the commands that MySQL supports. Chapter seven on Database Design contains a tutorial on taking a database to third normal form complete with Entity-Relationship diagrams, unique identifiers and relationships. In part four, the PHP chapter contains a mini-tutorial on PHP and a complete PHP application. While the level of thoroughness is nice in the sense that you do not have to refer to other volumes to comprehend the subject, it makes for some very intense reading because of the size of the book versus the topics covered.Read more ›
Most recent customer reviews
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. Read morePublished on June 27 2004
Great book to get you up and running with MySQL.
this is a typical book comes out of George Reese:
1. poorly written
2. shamelessly copy and paste existing materials from reference manual
3. Read more
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. Read morePublished on Aug. 30 2003 by Ewan Macpherson
The security chapter is well written and the reference section is comprehensive.Published on Feb. 26 2003
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 morePublished on Sept. 17 2002 by J. Whittenburg
The book title is completely mis-leading. It has little info on administrate the server - little practical details. Read morePublished on Aug. 22 2002 by Jack W. Wang
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
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Specific Databases > MySQL & mSQL
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Operating Systems > Unix
- Books > Computers & Technology > Programming
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Operating Systems
- Books > Textbooks > Computer Science & Information Systems > Programming Languages