Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition

(ebook) (audiobook) (audiobook)

Autorzy:: Tim King, George Reese, Randy Yarger

Promocja Przejdź

Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition Tim King, George Reese, Randy Yarger - okładka książki

Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition Tim King, George Reese, Randy Yarger - okładka audiobooka MP3

Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition Tim King, George Reese, Randy Yarger - okładka audiobooks CD

Wydawnictwo:: O'Reilly Media (Z chęcią przeczytam książkę w języku polskim)
Ocena:: Bądź pierwszym, który oceni tę książkę
Stron:: 444
Dostępne formaty:: ePub

Mobi

Ebook (118,15 zł najniższa cena z 30 dni)

~~149,00 zł~~ (-15%)
126,65 zł

Dodaj do koszyka lub Kup na prezent Kup 1-kliknięciem

(118,15 zł najniższa cena z 30 dni)

Przenieś na półkę

Do przechowalni

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.

Wybrane bestsellery

Tim King, George Reese, Randy Yarger - pozostałe książki

Ebooka przeczytasz na:

czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
systemach Windows, MacOS i innych

systemach Windows, Android, iOS, HarmonyOS
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi

Masz pytania? Zajrzyj do zakładki Pomoc »

Audiobooka posłuchasz:

w aplikacji Ebookpoint na Android, iOS, HarmonyOs
na systemach Windows, MacOS i innych

na dowolnych urządzeniach
i aplikacjach obsługujących format MP3
(pliki spakowane w ZIP)

Masz pytania? Zajrzyj do zakładki Pomoc »

Kurs Video zobaczysz:

Oceny i opinie klientów: Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition Tim King, George Reese, Randy Yarger (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.

Szczegóły książki

ISBN Ebooka:: 978-14-493-1678-5, 9781449316785
Data wydania ebooka:: 2002-04-23 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@helion.pl.
Język publikacji:: angielski
Rozmiar pliku ePub:: 2.7MB
Rozmiar pliku Mobi:: 2.7MB

Kategorie:
Bazy danych » MySQL - Programowanie

Spis treści książki

Managing and Using MySQL, 2nd Edition
- SPECIAL OFFER: Upgrade this ebook with OReilly
- A Note Regarding Supplemental Files
- Preface
  - Audience
  - Purpose
  - Using This Book
  - Conventions Used in This Book
  - Comments and Questions
  - Acknowledgments
    - From Randy Yarger
    - From George Reese
    - From Tim King
- I. Introduction
  - 1. MySQL
    - 1.1. Relational Databases
    - 1.2. The History of MySQL
    - 1.3. MySQL Design
    - 1.4. MySQL Features
    - 1.5. MySQL Applications
    - 1.6. What You Get
  - 2. Installation
    - 2.1. Preparation
    - 2.2. Unix Installation
      - 2.2.1. Binary (Tarball) Distributions
      - 2.2.2. Binary (RPM) Distributions
      - 2.2.3. Source Distributions
    - 2.3. Windows Installation
      - 2.3.1. Windows 9x Startup
      - 2.3.2. Windows NT/2000 Startup
  - 3. SQL According to MySQL
    - 3.1. SQL Basics
      - 3.1.1. The SQL Story
      - 3.1.2. The Design of SQL
      - 3.1.3. Sending SQL to MySQL
    - 3.2. Database Creation
    - 3.3. Table Management
    - 3.4. MySQL Data Types
      - 3.4.1. Numeric Types
      - 3.4.2. Character Types
      - 3.4.3. Binary Data Types
      - 3.4.4. Enumerations and Sets
      - 3.4.5. Other Kinds of Data
    - 3.5. Indexing
    - 3.6. Managing Data
      - 3.6.1. Inserts
      - 3.6.2. Sequence Generation
      - 3.6.3. Updates
      - 3.6.4. The WHERE Clause
      - 3.6.5. Deletes
    - 3.7. Queries
      - 3.7.1. Joins
      - 3.7.2. Aliasing
      - 3.7.3. Ordering and Grouping
        
        3.7.3.1. Basic ordering
        
        3.7.3.2. Localized sorting
        
        3.7.3.3. Grouping
      - 3.7.4. Limiting Results
    - 3.8. SQL Operators
      - 3.8.1. Logical Operators
      - 3.8.2. Nulls Idiosyncrasies
      - 3.8.3. Membership Tests
      - 3.8.4. Pattern Matching
    - 3.9. Advanced Features
      - 3.9.1. Full Text Searching
        
        3.9.1.1. The Basics
        
        3.9.1.2. Relevance values
        
        3.9.1.3. Boolean mode
        
        3.9.1.4. Tips
      - 3.9.2. Transactions
      - 3.9.3. Table Locking
      - 3.9.4. Functions
        
        3.9.4.1. Date functions
        
        3.9.4.2. String functions
      - 3.9.5. Outer Joins
      - 3.9.6. Unions
      - 3.9.7. Batch Processing
        
        3.9.7.1. Command-line loads
        
        3.9.7.2. The LOAD command
        
        3.9.7.3. Pulling data from MySQL
  - 4. Database Administration
    - 4.1. Configuration
      - 4.1.1. File Locations
      - 4.1.2. File Content
    - 4.2. Server Startup and Shutdown
      - 4.2.1. Unix/Linux
        
        4.2.1.1. SVR4
        
        4.2.1.2. Other Unix
      - 4.2.2. Mac OS X
      - 4.2.3. Windows NT/2000
    - 4.3. Logging
      - 4.3.1. The Error Log
      - 4.3.2. The Binary Log
      - 4.3.3. The Slow Query Log
      - 4.3.4. Log Rotation
    - 4.4. Backup
      - 4.4.1. mysqldump
      - 4.4.2. mysqlhotcopy
    - 4.5. Recovery
      - 4.5.1. mysqldump Recovery
      - 4.5.2. mysqlhotcopy Recovery
    - 4.6. Table Maintenance and Crash Recovery
      - 4.6.1. Checking a Table
      - 4.6.2. Repairing a Table
      - 4.6.3. Scheduled Table Checking
- II. MySQL Administration
  - 5. Performance Tuning
    - 5.1. An Approach to Performance Tuning
    - 5.2. Application Tuning
      - 5.2.1. Host Application Tuning
      - 5.2.2. SQL Query Tuning
        
        5.2.2.1. Index guidelines
        
        5.2.2.2. EXPLAIN SELECT
        
        5.2.2.3. Other options
    - 5.3. Database Server Tuning
    - 5.4. Operating System/Hardware Tuning
  - 6. Security
    - 6.1. Database Security
      - 6.1.1. User Management
      - 6.1.2. Privilege Management
        
        6.1.2.1. GRANT and REVOKE
        
        6.1.2.2. The security tables
      - 6.1.3. Recovering from Password and Permission Problems
    - 6.2. System Security
      - 6.2.1. Operating System Security
      - 6.2.2. Hardware Security
      - 6.2.3. Network Security
        
        6.2.3.1. Network topology
        
        6.2.3.2. Encryption
        
        6.2.3.3. Direct compromise
    - 6.3. Application Security
      - 6.3.1. The Application Server
        
        6.3.1.1. User management
        
        6.3.1.2. Resource protection
      - 6.3.2. Client Applications
  - 7. Database Design
    - 7.1. Database Design Primer
      - 7.1.1. Database Entities
      - 7.1.2. Entity Attributes
      - 7.1.3. Data Model
    - 7.2. Normalization
      - 7.2.1. First Normal Form
      - 7.2.2. The Unique Identifier
      - 7.2.3. Relationships
      - 7.2.4. Second Normal Form
      - 7.2.5. Kinds of Relationships
      - 7.2.6. Refining Relationships
      - 7.2.7. More 2NF
      - 7.2.8. Third Normal Form
    - 7.3. A Logical Data-Modeling Methodology
    - 7.4. Physical Database Design
      - 7.4.1. Tables and Columns
      - 7.4.2. Foreign Keys
- III. MySQL Programming
  - 8. Database Applications
    - 8.1. Architecture
      - 8.1.1. Client/Server Architecture
        
        8.1.1.1. Application logic
        
        8.1.1.2. Fat and thin clients
      - 8.1.2. Distributed Application Architecture
      - 8.1.3. Web Architecture
    - 8.2. Connections and Transactions
      - 8.2.1. Connections
      - 8.2.2. Transactions
        
        8.2.2.1. Transaction isolation levels
        
        8.2.2.2. Using READ UNCOMMITTED
    - 8.3. Object/Relational Modeling
  - 9. Perl
    - 9.1. Introduction to DBI
      - 9.1.1. Basic Perl Example
      - 9.1.2. Setting Up the Database and Program
      - 9.1.3. Error Handling and Attributes
      - 9.1.4. Introducing Bind Variables and Optimizations
    - 9.2. DBI and CGI
      - 9.2.1. Introduction to Perl CGI
      - 9.2.2. The Model/View/Controller Methodology
      - 9.2.3. A Sample CGI/DBI Program
    - 9.3. A General Model for Maintainable Perl Programs
      - 9.3.1. A Model for Relational Data
      - 9.3.2. Implementing the Model
        
        9.3.2.1. The Publisher class
        
        9.3.2.2. Methods that build and execute SQL
        
        9.3.2.3. Methods that handle WHERE clauses
        
        9.3.2.4. Getter/setter methods
        
        9.3.2.5. Primary key select method
        
        9.3.2.6. Constructors
        
        9.3.2.7. The DB class
        
        9.3.2.8. The mysql class
        
        9.3.2.9. The Cache class
      - 9.3.3. Example of the Model's Use
  - 10. Python
    - 10.1. DB-API
      - 10.1.1. The Database Connection
      - 10.1.2. Cursors
      - 10.1.3. Parameterized SQL
      - 10.1.4. Other Objects
    - 10.2. Proprietary Operations
    - 10.3. Applied DB-API
  - 11. PHP
    - 11.1. Introducing PHP
      - 11.1.1. A Short Language Primer
    - 11.2. Installing PHP
      - 11.2.1. Getting Started Under Unix
        
        11.2.1.1. Installation problems
      - 11.2.2. Getting Started Under Microsoft Windows
    - 11.3. Accessing the MySQL DBMS with PHP
      - 11.3.1. The Wedding Gift Registry Database
      - 11.3.2. Opening and Using a Database Connection
      - 11.3.3. Handling Results
      - 11.3.4. Frequently Used MySQL Library Functions
      - 11.3.5. Handling MySQL Errors
      - 11.3.6. Include Files
    - 11.4. Securing User Data
    - 11.5. Managing Sessions
    - 11.6. Writing Data with PHP
    - 11.7. Using the HTML <form> Environment
    - 11.8. Where to Find Out More
  - 12. C API
    - 12.1. API Overview
      - 12.1.1. The Connection
      - 12.1.2. Queries and Results
      - 12.1.3. Closing the Connection
    - 12.2. The C API in Practice
      - 12.2.1. Support Functions
      - 12.2.2. Quote Retrieval
      - 12.2.3. Adding Symbols
    - 12.3. Advanced Issues
  - 13. Java
    - 13.1. The JDBC API
      - 13.1.1. The JDBC Architecture
      - 13.1.2. Connecting to MySQL
        
        13.1.2.1. Data source connectivity
        
        13.1.2.2. Driver manager connectivity
      - 13.1.3. Maintaining Portability Using Properties Files
        
        13.1.3.1. Properties files
        
        13.1.3.2. Data sources revisited
    - 13.2. Simple Database Access
      - 13.2.1. Queries and Result Sets
      - 13.2.2. Error Handling and Clean Up
    - 13.3. Dynamic Database Access
      - 13.3.1. Metadata
      - 13.3.2. Processing Dynamic SQL
    - 13.4. A Guest Book Servlet
  - 14. Extending MySQL
    - 14.1. User-Defined Functions
      - 14.1.1. Standard Functions
        
        14.1.1.1. The init routine
        
        14.1.1.2. The main routine
        
        14.1.1.3. The deinit routine
      - 14.1.2. Aggregate Functions
        
        14.1.2.1. init
        
        14.1.2.2. reset
        
        14.1.2.3. add
        
        14.1.2.4. main
        
        14.1.2.5. deinit
        
        14.1.2.6. Aggregate example
      - 14.1.3. Calling a UDF
    - 14.2. Alternative Character Sets
      - 14.2.1. Simple Character Sets
      - 14.2.2. Complex Character Sets
- IV. MySQL Reference
  - 15. SQL Syntax for MySQL
    - 15.1. Basic Syntax
      - 15.1.1. Literals
      - 15.1.2. Identifiers
      - 15.1.3. Comments
    - 15.2. SQL Commands
      - ALTER TABLE
      - ANALYZE TABLE
      - CREATE DATABASE
      - CREATE FUNCTION
      - CREATE INDEX
      - CREATE TABLE
      - DELETE
      - DESCRIBE
      - DESC
      - DROP DATABASE
      - DROP FUNCTION
      - DROP INDEX
      - DROP TABLE
      - EXPLAIN
      - FLUSH
      - GRANT
      - INSERT
      - KILL
      - LOAD
      - LOCK
      - OPTIMIZE
      - REPLACE
      - REVOKE
      - SELECT
      - SET
      - SHOW
      - TRUNCATE
      - UNLOCK
      - UPDATE
      - USE
  - 16. MySQL Data Types
    - 16.1. Numeric Data Types
      - BIGINT
      - DEC
      - DECIMAL
      - DOUBLE
      - DOUBLE PRECISION
      - FLOAT
      - INT
      - INTEGER
      - MEDIUMINT
      - NUMERIC
      - REAL
      - SMALLINT
      - TINYINT
    - 16.2. String Data Types
      - BLOB
      - CHAR
      - CHARACTER
      - CHARACTER VARYING
      - LONGBLOB
      - LONGTEXT
      - MEDIUMBLOB
      - MEDIUMTEXT
      - NCHAR
      - NATIONAL CHAR
      - NATIONAL CHARACTER
      - NATIONAL VARCHAR
      - TEXT
      - TINYBLOB
      - TINYTEXT
      - VARCHAR
    - 16.3. Date Data Types
      - DATE
      - DATETIME
      - TIME
      - TIMESTAMP
      - YEAR
    - 16.4. Complex Data Types
      - ENUM
      - SET
  - 17. Operators and Functions
    - 17.1. Operators
      - 17.1.1. Rules of Precedence
      - 17.1.2. Arithmetic Operators
      - 17.1.3. Comparison Operators
      - 17.1.4. Logical Operators
    - 17.2. Functions
      - 17.2.1. Aggregate Functions
      - 17.2.2. General Functions
  - 18. MySQL PHP API Reference
    - 18.1. Data Types
    - 18.2. Functions
      - mysql_affected_rows
      - mysql_change_user
      - mysql_close
      - mysql_connect
      - mysql_create_db
      - mysql_data_seek
      - mysql_db_name
      - mysql_drop_db
      - mysql_errno
      - mysql_error
      - mysql_escape_string
      - mysql_fetch_array
      - mysql_fetch_assoc
      - mysql_fetch_field
      - mysql_fetch_lengths
      - mysql_fetch_object
      - mysql_fetch_row
      - mysql_field_flags
      - mysql_field_name
      - mysql_field_len
      - mysql_field_seek
      - mysql_field_table
      - mysql_field_type
      - mysql_free_result
      - mysql_get_client_info
      - mysql_get_host_info
      - mysql_get_proto_info
      - mysql_get_server_info
      - mysql_insert_id
      - mysql_list_dbs
      - mysql_list_fields
      - mysql_list_tables
      - mysql_num_fields
      - mysql_num_rows
      - mysql_pconnect
      - mysql_query
      - mysql_result
      - mysql_select_db
      - mysql_tablename
      - mysql_unbuffered_query
  - 19. C Reference
    - 19.1. Data Types
    - 19.2. Functions
      - mysql_affected_rows
      - mysql_change_user
      - mysql_character_set_name
      - mysql_close
      - mysql_connect
      - mysql_create_db
      - mysql_data_seek
      - mysql_debug
      - mysql_drop_db
      - mysql_dump_debug_info
      - mysql_eof
      - mysql_errno
      - mysql_error
      - mysql_escape_string
      - mysql_fetch_field
      - mysql_fetch_field_direct
      - mysql_fetch_fields
      - mysql_fetch_lengths
      - mysql_fetch_row
      - mysql_field_count
      - mysql_field_seek
      - mysql_field_tell
      - mysql_free_result
      - mysql_get_client_info
      - mysql_get_host_info
      - mysql_get_proto_info
      - mysql_get_server_info
      - mysql_info
      - mysql_init
      - mysql_insert_id
      - mysql_kill
      - mysql_list_dbs
      - mysql_list_fields
      - mysql_list_processes
      - mysql_list_tables
      - mysql_num_fields
      - mysql_num_rows
      - mysql_odbc_escape_string
      - mysql_odbc_remove_escape
      - mysql_options
      - mysql_ping
      - mysql_query
      - mysql_read_query_result
      - mysql_real_connect
      - mysql_real_escape_string
      - mysql_real_query
      - mysql_refresh
      - mysql_reload
      - mysql_row_seek
      - mysql_row_tell
      - mysql_select_db
      - mysql_send_query
      - mysql_shutdown
      - mysql_ssl_cipher
      - mysql_ssl_clear
      - mysql_ssl_set
      - mysql_stat
      - mysql_store_result
      - mysql_thread_id
      - mysql_thread_safe
      - mysql_use_result
  - 20. The Python DB-API
    - 20.1. Module: MySQLdb
      - 20.1.1. Module Attributes
        
        apilevel
        
        paramstyle
        
        quote_conv
        
        threadsafety
        
        type_conv
      - 20.1.2. Module Methods
        
        MySQL.connect()
      - 20.1.3. Connection Attributes
        
        db
      - 20.1.4. Connection Methods
        
        close()
        
        commit()
        
        cursor()
        
        rollback( )
      - 20.1.5. Cursor Attributes
        
        arraysize
        
        description
        
        rowcount
      - 20.1.6. Cursor Methods
        
        callproc( )
        
        Method: close( )
        
        execute( )
        
        executemany( )
        
        Method: fetchall( )
        
        fetchmany( )
        
        fetchone( )
        
        insert_id( )*
        
        nextset( )
        
        setinputsizes( )
        
        setoutputsize( )
- Index
- About the Authors
- Colophon
- SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition

Ebook (118,15 zł najniższa cena z 30 dni)

Najczęściej kupowane razem

Opis książki: Managing & Using MySQL. Open Source SQL Databases for Managing Information & Web Sites. 2nd Edition

Wybrane bestsellery

Tim King, George Reese, Randy Yarger - pozostałe książki

Ebooka przeczytasz na:

Audiobooka posłuchasz:

Kurs Video zobaczysz:

Szczegóły książki

Spis treści książki

O'Reilly Media - inne książki

Poinformuj mnie

Poinformuj mnie

Twoje uwagi do kursu

Wybierz metodę płatności

Przenieś na półkę

Dodano produkt na półkę

Usunięto produkt z półki

Przeniesiono produkt do archiwum

Przeniesiono produkt do biblioteki