pbstudio
e-Book Managing and Using MySQL (2nd Edition) download

e-Book Managing and Using MySQL (2nd Edition) download

by Tim King,Randy Yarger,Hugh E. Williams,Randy Jay Yarger,George Reese

ISBN: 0596002114
ISBN13: 978-0596002114
Language: English
Publisher: O'Reilly Media; Second edition (April 2002)
Pages: 442
Category: Networking and Cloud Computing
Subategory: Technologies

ePub size: 1427 kb
Fb2 size: 1946 kb
DJVU size: 1840 kb
Rating: 4.1
Votes: 991
Other Formats: lrf rtf mbr lrf

George Reese (Author), Randy Yarger (Author), Hugh E. Williams (Author), Randy Jay Yarger (Author) & 2 more.

George Reese (Author), Randy Yarger (Author), Hugh E. ISBN-13: 978-0596002114. Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies.

MySQL is free for nonprofit use and costs a small amount for commercial . This book includes introductions to SQL and to relational database theory.

MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use.

Managing and Using MySQL.

Authors: Tim King, George Reese, Randy Yarger, Hugh E. Williams, Randy Jay Yarger. CISSP Exam Cram 2. Implementation.

This book has all you need to take full advantage of this powerful database . product description page.

This book has all you need to take full advantage of this powerful database management system.

Finding books BookSee BookSee - Download books for free. Tim King, George Reese, Randy Yarger, Hugh E.

Find nearly any book by Randy Jay Yarger. Get the best deal by comparing prices from over 100,000 booksellers. Coauthors & Alternates. Learn More at LibraryThing.

Managing and Using Mysql, Paperback by Reese, George; Yarger, Randy Jay; King, Tim; Williams, Hugh . ISBN 0596002114, ISBN-13 9780596002114, Brand New, Free P&P in the UK Covers topics including.

Managing & Using MySQL by Randy Jay Yarger, Tim King, George Reese (Paperback, 2002). Brand new: lowest price.

Randy Jay Yarger (author), George Reese (author), Tim King (author).

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.

Comments:
Tane
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. For example, the PHP section documents the relevant function calls, since PHP uses different functions to access MySQL than it does to access, say, ODBC databases, while the Java section focuses on JDBC (Java Database Connectivity) driver configuration since the JDBC API is database independent.
Finally, there is a reference section and a good, complete index.
If what you want to do is get a small database up and running in a minimum of time with a minimum of hassle, this is the book for you. If you want more than an introductory level of detail and depth, though, you might look at other books; Leon Atkinson's "Core MySQL", for example, has more complete coverage, though the writing style is not as clear and direct.

Gela
It's disappointing to buy a book that looks like it's a deal only to find out that, even though it's in great condition, it is several versions of the software old and thus is basically useless...

lacki
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. But if your looking for this book to tell you how to manage MySQL look on, this book is not for you! It's pretty weak in that area (as is the official MySQL documentation). But again, as a programmer I've found this book invaluable as a resource and would never be without it. I'd recommend it for novices and advanced users.

Hellblade
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. they do have is not very good, you would be better suited getting the docs from mysql.org.
Jeremy

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

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

ISBN: 2212125542
ISBN13: 978-2212125542
language: French
ISBN: 0321949366
ISBN13: 978-0321949363
language: English
Subcategory: Databases and Big Data
ISBN: 0595154824
ISBN13: 978-0595154821
language: English
Subcategory: Operating Systems
ISBN: 0201657716
ISBN13: 978-0201657715
language: English
Subcategory: Databases and Big Data
ISBN: 1590597087
ISBN13: 978-1590597088
language: English
Subcategory: Networking and Cloud Computing
e-Book Mastering Microsoft SQL Server 2005 Express Edition download

Mastering Microsoft SQL Server 2005 Express Edition epub fb2

by Susan Sales Harkins,Mike Gunderloy
ISBN: 0782144020
ISBN13: 978-0782144024
language: English
Subcategory: Programming
e-Book MySQL Cookbook download

MySQL Cookbook epub fb2

by Paul DuBois
ISBN: 059652708X
ISBN13: 978-0596527082
language: English
Subcategory: Databases and Big Data
ISBN: 1430239816
ISBN13: 978-1430239819
language: English
Subcategory: Databases and Big Data
ISBN: 0929306457
ISBN13: 978-0929306452
language: English
Subcategory: Databases and Big Data
ISBN: 0201596288
ISBN13: 978-0201596281
language: English
Subcategory: Operating Systems