Managing & Using MySQL und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr


oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Beginnen Sie mit dem Lesen von Managing & Using MySQL auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Managing & Using MySQL (Classique Us) [Englisch] [Taschenbuch]

George Reese , Randy Jay Yarger , Tim Kin
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
Statt: EUR 30,89
Jetzt: EUR 30,82 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
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
Auf Lager. Zustellung kann bis zu 2 zusätzliche Tage in Anspruch nehmen.
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 17,30  
Taschenbuch EUR 30,82  

Kurzbeschreibung

10. Mai 2002 Classique Us
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.

Hinweise und Aktionen

  • 5-EUR-Gutschein für Drogerie- und Beauty-Artikel:
    Kaufen Sie für mind. 25 EUR aus den Bereichen PC-und Videogames, Musik, DVD/Blu-ray und Hörbücher sowie Kalender und Fremdsprachige Bücher ein; der 5-EUR-Gutschein wird in Ihrem Amazon-Konto automatisch nach Versand der Artikel hinterlegt. Die Aktion gilt nicht für Downloads. Zur Aktion| Weitere Informationen (Geschäftsbedingungen)
  • Studienbücher: Ob neu oder gebraucht, alle wichtigen Bücher für Ihr Studium finden Sie im großen Studium Special. Natürlich portofrei.


Produktinformation

  • Taschenbuch: 448 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 2., Aufl. (10. Mai 2002)
  • Sprache: Englisch
  • ISBN-10: 0596002114
  • ISBN-13: 978-0596002114
  • Größe und/oder Gewicht: 23,4 x 17,9 x 2,7 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 1.011.673 in Englische Bücher (Siehe Top 100 in Englische Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Amazon.de

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

Synopsis

MySQL is a 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. 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. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has an 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.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
2 von 2 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Perfect book for MySQL and even databases in general 12. Dezember 2002
Format:Taschenbuch
This book is one of the best database book I've ever read. It starts with an introduction to MySQL (including history and installation). The introduction is followed by a very nice overview to SQL in general and according to MySQL. Then there is larger part of database administration - also including general and specific aspects to MySQL. The authors also explains very well the topics Performance Tuning, Security and Database Design. (Of course, they also don't lose the overall view there).
To give programmers many practical hints how to work with MySQL specific chapters for Perl, Python, PHP, C and Java are added. Additional it is also explained how to extend MySQL with user defined functions. At last a voluminous MySQL reference finish the book.
The book is also very easy to read with a lax and enjoining language. I could neither find a spelling mistake nor a typographic one.
There's not much I missed at this book. Perhaps some more examples would be nice, but that's not really a problem as the explanation are so good, that you needn't many examples. The only thing I really missed are the new transaction features of MySQL. (Of course, they are too new to be handled by this book). However the author also explains transaction handling in general and what was planned to be done with MySQL when he wrote this book. So it wasn't a big problem to understand the according web sites.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 3.3 von 5 Sternen  14 Rezensionen
35 von 36 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen A good book covering a lot of topics 9. September 2002
Von C. M. Lowry - Veröffentlicht auf Amazon.com
Format:Taschenbuch
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 administrators. The book consists of four major parts. The first part is the Introduction, which contains chapters on MySQL in general, installation on Unix and Windows, SQL for MySQL, and general Database Administration. This is accomplished in less than eighty pages which makes for brief explanations, limited illustrations, and examples. The second part is the MySQL Administration. This part has chapters on Performance Tuning, Security, and Database Design. The third part is MySQL Programming. The chapters' topics include general database applications, Perl, Python, PHP, C API, Java, and extending MySQL. Part four is the MySQL Reference. SQL syntax for MySQL, MySQL data types, Operators and Functions, MySQL PHP API Reference, C Reference, and Python DB-API are the chapter topics included in this part.
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.
Overall, I like the book as a general tool, however there are certain omissions, for example: there is no reference phpMyAdmin or WinMySQLadmin. These tools are very easy to use and helpful in working with MySQL. In addition, the topic of creating InnoDB or BDB tables for transaction support is not addressed. The explanation of granting privileges in MySQL was a little confusing. Some supporting illustrations or diagrams would be well received there. The book is fairly successful in covering its broad topic domain. In conjunction with the MySQL manual, the book should meet most of my needs, but if I were a full time database administrator, I would probably want a dedicated reference book.
20 von 20 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Good Introduction to MySQL - But Only an Introduction 6. November 2003
Von Warren J. Dew - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Von Amazon bestätigter Kauf
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.
13 von 14 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Excellent Reference But Not Much On Managment 18. September 2002
Von J. Whittenburg - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Von Amazon bestätigter Kauf
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.
13 von 15 Kunden fanden die folgende Rezension hilfreich
1.0 von 5 Sternen Not very useful, no "Managing" covered 14. Oktober 2003
Von Todd E Smith - Veröffentlicht auf Amazon.com
Format:Taschenbuch
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.
2 von 2 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Lack of In-Depth Information 28. Juni 2004
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format:Taschenbuch
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.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen
ARRAY(0xa7646900)

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar