MySQL in a Nutshell 2e

De (autor)
Notă GoodReads:
en Limba Engleză Paperback – 06 May 2008
Contains the commands and programming information for version MySQL 5.1. This title presents a reference to MySQL statements, functions, and administrative utilities. It provides programming language APIs for PHP, Perl, and C. It also covers replication, triggers, and stored procedures.
Citește tot Restrânge

Preț: 17354 lei

Puncte Express: 260

Preț estimativ în valută:
3356 3600$ 2951£

Carte disponibilă

Livrare economică 04-10 aprilie
Livrare express 07-15 aprilie pentru 7702 lei

Preluare comenzi: 021 569.72.76


ISBN-13: 9780596514334
ISBN-10: 0596514336
Pagini: 564
Ilustrații: 1, black & white illustrations
Dimensiuni: 151 x 227 x 29 mm
Greutate: 0.85 kg
Ediția: 2 Rev ed.
Editura: O'Reilly


Preface; The Purpose of This Book; How This Book Is Organized; Conventions Used in This Book; Using Code Examples; Request for Comments; Safari® Enabled; Acknowledgments; Introduction and Tutorials; Chapter 1: Introduction to MySQL; 1.1 The Value of MySQL; 1.2 The MySQL Package; 1.3 Licensing; 1.4 Mailing Lists; 1.5 Books and Other Publications; Chapter 2: Installing MySQL; 2.1 Choosing a Distribution; 2.2 Unix Source Distributions; 2.3 Unix Binary Distributions; 2.4 Linux RPM Distributions; 2.5 Macintosh OS X Distributions; 2.6 Novell NetWare Distributions; 2.7 Windows Distributions; 2.8 Postinstallation; Chapter 3: MySQL Basics; 3.1 The mysql Client; 3.2 Creating a Database and Tables; 3.3 Show Me; 3.4 Inserting Data; 3.5 Selecting Data; 3.6 Ordering, Limiting, and Grouping; 3.7 Analyzing and Manipulating Data; 3.8 Changing Data; 3.9 Deleting Data; 3.10 Searching Data; 3.11 Importing Data in Bulk; 3.12 Command-Line Interface; 3.13 Conclusion; SQL Statements and Functions; Chapter 4: Security and User Statements and Functions; 4.1 Statements and Functions; 4.2 SQL Statements in Alphabetical Order; 4.3 Functions in Alphabetical Order; Chapter 5: Database and Table Schema Statements; 5.1 Statements and Clauses in Alphabetical Order; Chapter 6: Data Manipulation Statements and Functions; 6.1 Statements and Functions Grouped by Characteristics; 6.2 Statements and Clauses in Alphabetical Order; 6.3 Functions in Alphabetical Order; Chapter 7: Table and Server Administration Statements and Functions; 7.1 Statements and Clauses in Alphabetical Order; 7.2 Functions in Alphabetical Order; Chapter 8: Replication Statements and Functions; 8.1 Merits of Replication; 8.2 Replication Process; 8.3 The Replication User Account; 8.4 Configuring the Servers; 8.5 Copying Databases and Starting Replication; 8.6 Starting Replication; 8.7 Backups with Replication; 8.8 SQL Statements and Functions in Alphabetical Order; 8.9 Replication States; Chapter 9: Stored Routines Statements; 9.1 Statements in Alphabetical Order; Chapter 10: Aggregate Clauses, Aggregate Functions, and Subqueries; 10.1 Aggregate Functions in Alphabetical Order; 10.2 Subqueries; Chapter 11: String Functions; 11.1 String Functions Grouped by Type; 11.2 String Functions in Alphabetical Order; Chapter 12: Date and Time Functions; 12.1 Date and Time Functions Grouped by Type; 12.2 Date and Time Functions in Alphabetical Order; Chapter 13: Mathematical Functions; 13.1 Functions in Alphabetical Order; Chapter 14: Flow Control Functions; 14.1 Functions in Alphabetical Order; MySQL Server and Client Tools; Chapter 15: MySQL Server and Client; 15.1 mysql Client; 15.2 mysqld Server; 15.3 mysqld_multi; 15.4 mysqld_safe; Chapter 16: Command-Line Utilities; APIs and Connectors; Chapter 17: C API; 17.1 Using C with MySQL; 17.2 Functions in Alphabetical Order; 17.3 C API Datatypes; Chapter 18: Perl API; 18.1 Using Perl DBI with MySQL; 18.2 Perl DBI Reference; 18.3 Attributes for Handles; Chapter 19: PHP API; 19.1 Using PHP with MySQL; 19.2 PHP MySQL Functions in Alphabetical Order; Appendixes; Data Types; Numeric Data Types; Date and Time Data Types; String Data Types; Operators; Arithmetic Operators; Relational Operators; Logical Operators; Bitwise Operators; Regular Expressions; Server and Environment Variables; Colophon;