《The Definitive Guide to MySQL53rdEdition_Michael Kofler_共785页》pdf电子书免费下载
下载方式一：
百度网盘下载地址：https://pan.baidu.com/s/1VtZfidjdQpChIPjevS-v8A
百度网盘密码：1111
下载方式二：
http://ziliaoshare.cn/Download/ae_123662_pd_TheDefinitiveGuidetoMySQL53rdEdition_MichaelKofler_G785Y.zip
|
|
作者：empty 页数：785 出版社：empty |
《The Definitive Guide to MySQL53rdEdition_Michael Kofler_共785页》介绍
All rights reserved.No part of this work maybe reproduced or transmitted in any for mar by any meanselectronic or mne chanical， including photocopying recording， or by any information storage or retrievalsystem， without the prior written permission of the copyright owner and the publisher.ISBN I pbk) ：1-59059-535-1Printed and bound in the United States of America 987654321Trademarked names may appear in this ba ok.Rather than use a trademark symbol with every ac currenceof a trademarked name， we use the names an lyin an edit on a lashon and to the benefit of the trademarkowner with no intention of infringement of the trademark.Translator and Editor：David KramerJason Gil mare， Jonathan Hassell， ChrisM lls， Dominic Shakeshaft， jim Sum serAssociate Publisher Grace WongProject Manager：Beth ChristmasCopyEdit Manager：Nicole LeClercAssistantProductionDirector：KariBraoks-CopanyProduction Editor：Laura Ch euCampos it or：Linda Weidemann， Wal f Creek PressProofreader：April EddyArtist：Kinetic Publishing Services， LLCInterior Designer：Van Winkle Design GroupCaver Designer Kurt KramesManufacturing Manager：Tom De hol skiDistributed to the boak trade worldwide by Spng er Verlag NewYork， Inc， 233 Spring Street， 6th Floor，NewYork.NY 10013.Phone 1-800-SPRINGER， fax 201-348-4505， c mail orders-nye springer-sbn.con， orvisithttp：//eed.springeronline.com，Far information on translations， please contact A press directly at256uNinth Street， Suite 219， BerkeleyThe information in this book is distributed on an as is basis， without warranty Although every precautionhas been taken in the preparation of this work， neither the author tsn or A press shall have any liability to.....a......mahthwxosoudmaeasedarl to he aud yai deyby the infarmation contained in this work.Thesourcecodeforthisbookisavailabletoreadersathttp：//www.apress.comintheSourceCadesection.
《The Definitive Guide to MySQL53rdEdition_Michael Kofler_共785页》目录
CHAPTER 15PHP..
CHAPTER 16Perl..
M CHAPTER 17Java(JDBC and Connector/J) .
CHAPTER 18C.
CHAPTER 19VisualBasic 6/VBA..
CHAPTER 20VisualBasic.NET and C#.
PART 5mu■Reference
CHAPTER 21SQL Reference..
CHAPTER 22MySQL Tools and Options.
CHAPTER 23API Reference.
PART 6Appendixes
APPENDIX AGlossary..
APPENDIX BThe Files for this Book..
APPENDIX CBibliography.
M INDEX
Contents
About the Author..
About the Translator..
Preface..
PART 1■■Introduction
E CHAPTER 1What Is MySQL?..
CHAPTER 2
What is a Database?.
Re lions， Database Systems， Servers， and Cients
Relational Versus Object-Oriented Database Systems
Tables， Records， Fields， Queries， SQL， Index， Keys.
MySQL..
Limitations of MySQL..
MySQL Version Numbers..
MySQL Licens ng.
Al tema tives to MySQL
Features of MySQL
Apha， Beta， Gamma， Production(Generally Available) .
MySQL Functions Ordered by Version Number..
Rghts and Du ts with Respect to the GPL
Use of MySQL with an OpenSource License..
Use of MySQL with a Commercial License.
Commercial Licenses for Client Libraries
(Connector/ODBC， Connector/J， etc) ..
Client Licenses for the PHP Project， F(L) OSS Except on
MySQL Version Names..
Support Contracts.
Summary.
The Test Environment
Windows or Unix/Linux?.
Installation Under Windows..
MySQL in Pract ce(Public Internet Server) .
Development Environment.
I CONTENTS
Instalation Under SUSELinux 9.3.
Installing Apache 2， PHP 5， and Perl.
Installing MySQL 5.0.
Install ng Apache 2
Install ng MySQL 5
Comp lng PHP 5.
Install ng Per 15.8.
Install ng Bitkeeper.
Downloading the MySQL Developer Version..
Comp i ing MySQL..
Insta ation Under RedHat Enterpr se Liu x 4
Com pig the MySQL Developer Version(Linux.
Configuring Apache.
Configuring PHP.
Contig uring MySQL
Seting Up the mysql Database for Managing Access Pri leges.
Configuration Files and In it-V Scripts.
Starting the MySQL Server.
Contig ura tn Files..
Elementary Settings.
Access Pri i leges for Indi dual Director es(.htaccess) .
LauncigteMySOL Server.
Assumptions.-.
Execu ing the mysql Command-Line Interpreter.
Setting Up the Database.
Creating Tables.
Why Make lt Comp i cated， When It Could Be So Much Easier?
The mysql Interface Versus the mysqli Interface.
Establ shing a Connection to the Database.
Evaluating the Data and Storing It in the Database
Displaying the Sur vay Results..
Program Code(results.php) .
The Resulting HTML Code..
Launching mysql..
mysql Op tons.
Using mysql nter actively.
Tips for Using mysql Under Uni Linux.
Tips for Using mysql Under Windows..
Processing SQL Files with mysql..
Server Information.
Service Control.
Startup Variables.
User Administration.
Server Connections.
Ho alth.
Server Logs，
Backup..-
Restore.
ReplicationS latus..
Catalogs.
Input and Execution of SQL Commands.
Changing Data in SELECT Results..
History and Bookmarks for SQL Commands..
Executing Several Commands at Once(Scripts) .
Stored Procedures..
MySQL Help..
CHAPTER 3
Introductory Example(An Opinion Poll with PHP) ..
Overview..
Database Development..
The Questionnaire.
Quesion na ie Evaluation and Displaying Results.
Ideas for improvements..
User Interfaces
mysql.
mysqladmin.
mysqldump.
wi
PART 2mmm Administrative Tools and
CHAPTER 4mysql， mysqladmin， and mysqldump.
CHAPTER 5
MySQL Administrator and MySQL Query Browser . 71
Installation.71
Establishing a Connection.72
MySQL Administrator..73
MySQL Query Browser.82
.VII CDN TENTS
.CHAPTER 6
I CHAPTER 7
PART 3■mm
CHAPTER 8
phpMyAdmin.
I CONTENTS
Installation and Configuration.
User Management Secur ng MySQL..
Creating and Edi ing Databases..
Viewing， Insert ng， and Editing Data.
Executing SQL Commands.
Import and Export
Server Administrat on.
Aux ary Func tons..
Install ng phpMyAdmin Files..
Configuring phpMyAdmin..
config Authentication.
http and Co kAu the ntc aicn
Securing MySQL.
Creating New Users， .
Creating a Database..
Editing Existing Tables..
Setting ForeignKey Rules..
Documenting the Database Structure.
Database Backup(SQL Fl) .
Exporting Tables{CSV TextFile) ，
Impor in ga Database or Tables(SQL File) .
Inserting Table Data(Text Fle) ..
Cretin ga Database for php My Admi.
SQL Bookmarks and History.
Saving Informaion on Relations.
Creating a PDF Relational Diagram.
Transformations(Alte mative Representation of Column Contents) . 115
Setting Up ODBC DataSources..118
Importing and Expo ring Tables.122
Converter：Access>MySQL(exports q.txt) ..123
Im poing Data wi hMS Query..125
Connector/J.，127
Installation，.127
Creating a Connection to a MySQL Database.128
Tables..130
Queries..131
Forms， Reports， and Additional Functions..132
Establishing a DataSource..134
Importing Data..134
My l SAM Tables.
InnoDB Tables.
HEAP Tables.
Temporary Tables..
Other Table Types..
Table Files..
Integers(xxx INT) ..
Fixed-Point Numbers(DECIMAL) .
DateandTime(DATE， TIME， DATETIME， TIMESTAMP) .
Character Strings(CHAR， VARCHAR， xx TEXT) ..
Binary Data(xxx BLOB and BIT) ..
Options and Attributes..
Rules for Good Database Design.
Tips for Naming.
Tips on the Design Process.
A First Attempt..
The Frst Normal Form..
Second Normal Form..
Third Normal Form.
Normalization Theory.
Hierarchy Problems.161
Building the Hierarchy Tree.
Searching for Lower-Ranked Categories in the categories Table.
Searching for Higher-Ranked Categories in the categories Table .. 165
MicrosoftOffice， OpenOffice/StarOffice.，
Install ng Connector/ODBC.
Microsoft Acce5s.
Microsoft Excel..
Connector/J Installation..
Open Of ice/StarOffice Base.
OpenOffice/Star Of ice DataSource View.
Fundamentals
Database Design..
Further Reading..
Table Types..
MySQL DataTypes.
Tips and Tricks on Database Design.
Normalization Rules..
Managing Hierarchies..
ix
CDN TENTS
CHAPTER 9
CHAPTER 10
Relations..
Variables..
IF Queries..
CASE Branching..
Creating a New Table by Copying..
Copying into Existing Tables..
PivotTables for Book Titles， Languages， and Categories.
PivotTable Query Results by Month..
Syntax Variants..
Examples..
Searching for Titles Without Authors.
Searching for Invalid Publisher Links.
InvalidRecordsin1：nRelations..
Searching for Invalid Links Between Authors and Titles
n：m Relation) .
Searching Data(SELECT) ..
Chang ng Records(UPDATE and DELETE..
Delete All Threads Except the Last 500..
Selection Without a random Column.
Selection with a random Column.
Selection on the Basis of an id Column.
Fundamentals..
Book Search.
Forum Search..
Syntax.
GET_LOCK and RELEASE_LOCK..
Why Transactions.
Controling Transactions..
Try ng Out Transac ins.
Transactions and Locking..
Isolation Degree for Transactions..
Error Protection..
Communication Between the Client and the MySQL Server.， .
Access Administration..
Protecting the MySQL Instal at on.
Creating a New Database and User.
Granting the Right to Create One'sOwn Database..
Oops ll Forgot the root Password l..
Two-Tiered A ocess Control， .
Privileges-.
The mysql Database..
The user Table..-..
The user， Host Column.
The db and host Tables， .
The tables_priv and columns_priv Tables.
The procs_priv Table.
ChangigAcca5sPigeswih GRANT and REVOKE
Viewing Acc ass Privileges with SHOW GRANT.
Changing a Password with mysqladmin.
Updating the Client Libraries.
old-passwords Mode..
Parallel Operation with Old and New Passwords.
Possible Causes of the Connect on Dii culty..
Further Tips for Er or-Checking.
Securty at the System Level
Security Measures in the Storage of Cr ical Data.
The MySQL Server as Security Risk..
Spe if ng Coordinates.
Well-Known Text， Well-Known Binary(OpenGIS) ..
xii
Running the MySQL Server Without root or Adminis rat or Privileges .. 296
Network Security， Firewall， .297
GIS Functions.299
GIS Data Formats..299
I CONTENTS
.345
DataTypes.
Smp le Geom etc Fun cons.
Function for Spatial Analysis..
Indexing Geometric Data.
Creating the Table..
Inserting the Data..
Querying the Data..
DataSource and import.
Import..
Radial Search.
Stored Procedures and Triggers.
Why Stored Procedures?Why Trg gers?， .
Hello， SP World!..
SP Implementation.
SP Administration..
SP Syntax and Language Elements.
SP Examples.
Triggers..
CHAPTER 13
CHAPTER 14
Triggers.
The Command Interpret my sqi..
The MySQL Query Browser..
Creat ng， Edi ing， and Deleting SPs.
Se cunty.
Backup and Restora in of SPs
General Syntax Rules.
Ca ling SPs{CALL) .
Parameters and Re tum Values..
Encaps u at n of Commands BEGIN-END) .
Branching-.
Lo0pS..
Error Handing(Handlers)
Cursors..
Adding a Category.
Adding a Title.
Determining Parent Categori 8s..
Administration and Server Configuration..
First Steps.
Backups.
Database Migration.
Importing and Exporting Text Files
Logging..
Replication.
Producing aL it of Hierarchical y Ordered Categories..
Creating a Trigger..
Deleting a Trigger.
Implementation Details and Administra i a Assitance.
Functional Limitations.
An Exam plo.
Uing Administ veTo os
Setting the root Password..
MySQL Sarver Configuration File.
Re staring the MySQL Server，
Basic Configuration of the MySQL Server..
Direct ones..
Communication Set ings.
Default Table Format..
Default Character Set and Sort Order for New Tables.
TimeZones..
The Language for Error Messages..
SQL Mode..
Backing Up Databases(mysqldump) .
Restoring a Database(mysql..
Fast Backups(mysql hot copy) .
Special Characters in the Imported or Exported File
XV
Working with Character Strings， Numbers， Dates， and BLOBs.
Importing with LOAD DATA IN FILE..
Importing with mysqlimport..
Expo rng with SELECT.INTO OUTFILE.
Exporting wth mysqldump.
Exporting with mysql in Batch Mode.
Why Logging?..
Drawbacks.
Logging Changes(update log) ..
Errors， Logins， and Slow Queries.，
Administrat on of Logging Files.
Introduction..
Setting Up the Replication Master System.
Seting Up the Replication Slave System.
Setting Up a Replication System wih LOAD DATA
InsideR aplication.
Client Programming..
Administrat on of InnoDB Tables.
Server Tuning..
ISP Database Adminis ration.
mysql Functions..
my sli Classes， Me the ds， and Proper tes.
0ut sourcing Database Functions into a Class.
Displaying a SELECT Result As a Table.
CharacterS rings， Dates， Times， BLOBs， and NULL
n set ng Linked Data Records.
Processing Input from Forms.
Pagewise Re presenation of Search Results..
Managing Hierarchical Data.
SpeedO pm ization.
Unicode.
Binary Data(BLOBs) and Images.
Stored Procedures.a
SP Administrator..
I CONTENTS
myisamchk.
Using my am chk.
Speed Opi mization， Memory Usage..
Shrinking and Optimizing MyISAM Tables.
Repairing MyISAM Tables.
Compressing My SAMT abes myisam pack)
Tablespace Administration..
Logging Files..
Opt al Memory Management..
Query Cache..
Working with ssh..
Working via phpMyAdmin.
Implementing Custom PHP Scripts for Adminis ration..
Custom Perl Scripts for Admn is raton.
Programming
Establishing a Connection.
Execu ing SQL Commands.
Evalua ing SELECT Results..
Transac ions.
Er or Hand ng and Search.
Which Will It Be：mysql or mysqli?..
Availability Tests.
Overview of Classes..
Making the Connection..
Executing SQL Commands..
Evaluating SELECT Results(mysqli_result) ..
Execu ing Several SQLCommand sat Once.
SQL Commands with Parameters(Prepared Statements) ..
Transact ons.
More Secu ty with a Separate Password Fie..
Securty and Convenience wth the My Db Class.
Character Strings and BLOBs.
Dates and Times.
NULL..
Code Structure..
Creating the Form..
va dation of Form Data..
Storing the Form Data.
Deleting a Title..
Room for Improvement..
Code Structure..
Author Search.
Title Search..
Displaying Search Results.
Links to Additional Pages..
Code Structure..
Displaying the Category Tree..
In se ring Subcategories.
Deleting Categories and Subcategories
Searching for Parent Categories.
Searching for Subcategories.
Ground Rules for Eft i cient Code Execu ion.
Statist cal and Benchmarking Help.
Example：Generating the Category ListE ficiently.
Setting the HTML and HTTP Co dig.
Fundamentals and Programming Techniques..
Program Code..
Installation.
Using the Program.
I CDN TENTS
H CHAPTER 16
CHAPTER 17
CHAPTER 18
CHAPTER 19
CHAPTER 20
Perl
Programming Techniques..
The Modules DBl and DBD：mysql.
Establishing a Connection to the Database.
Executing SQL Commands.
Evaluating SELECT Queries..
CharacterS ting5BLOB 5， DATE 5， SETs， ENUMs， and NULL.
DBD：mysql-specificMethodsandAttributes.
Unicode..
Transactions.
Error-Handling.
Book Search(my library-find.p) .
Simple Input of New Books(my library-simple input.pl.
Book Search(my library-find-utf 8.pl.
Input of New Bocks(my library-simple input-utt 8.pl.
The Java Installation
Connector/J Installation
A First Example，
Establ shing the Connection，
Problems in Establishing a Connection
Executing SQL Commands.
Evaluating SELECT Queries.
Prepared Statements.
Transactions..
Batch Commands..
Working with Binary Data(BLOBs) ..
Assumptions.
Introductory Example..
Comp ling and Linking.
Makefile.
EvaluationoftheConfigurationFemy.cnf..
Evaluation of Options in the CommandLine.
Simple Commands..
Execut g Several Commands at a Time.
Prepared Statements..
Character Set Settings(Unicode) .
Storing Binary Data in a Database and Reading It..
Introduction.
Establishing the Connection with aDS N..
Establ shing a Connection Without aDS N..
A DO Programming Techniques..
Example：authors Column for the titles Table..
Example：Adding a New BookTitle..
Example：Storing an Image Fle in BLOB Format and
Then Reading It.
Properties of mssql 2 mysql..
Assump tons..
Restrictions.
Howto Use lt..
Setting Parameters..
Installation.
Application.
Example..
Estab i hing a Connection with Connector/Net.
Estabs hng the Connect on wih the ODBC DataProvider..
Example：Deleting Invalid Data Records(my l ray..
CGI Example：Library Management(my library..
CGI Unicode Example..
Java(JDBC and Connector/J) .
Introduction.
Programming Techniques..
C.
The CAPI libmysql client) .
Hello， World 1
Establ shing the Connection.
Executing SQL Commands..
Wong whB nary Data and Spec