学习MySQL(影印版)
学习MySQL(影印版)
Saied Tahaghoghi, Hugh E. Williams
出版时间:2007年06月
页数:620
无论您正在做一项生意,或者为一个俱乐部保存会员和会议记录,还是试图整理一大堆互不相关的信息,您都会发现MySQL是让您终身受益的好帮手。而除了《学习MySQL》,还没有其他更好的途径可以学习如何让MySQL为您所用。它是一本信息密集的教材,包含了各种各样的知识点,例如详尽的数据库指令,帮助您架设并设计一个高效率的数据库,创建强大的SQL查询语句,配置MySQL数据库以提高安全性,从您的数据中检索有用的信息。
在讲述基础知识之后,《学习MySQL》将带您深入MySQL的细微精妙之处,包括复杂的查询和合并(join)、如何让PHP或者Perl通过网络对数据库进行操作以及如何对数据库进行备份或者安全管理等维护工作。
书中的主题涵盖了以下内容:
*在Linux、Windows和Mac OS X平台上安装MySQL
*使用SQL语句进行基本和高级的查询
*用户管理和安全
*备份和恢复
*数据库性能优化
*使用PHP和Perl编写命令行或者网络数据库应用程序
MySQL是最受欢迎的开源数据库,它易于架设和管理,提供了关系型数据库的完整功能。无论是以前从未接触过数据库还是已经做完好几个使用了MySQL的项目,您都将发现《学习MySQL》中的精辟见解会在您的职业生涯里发挥作用。
Saied Tahaghoghi是RMIT大学计算机科学与信息技术学院的高级讲师, 他也是RMIT搜索引擎组的成员, 在组内负责指导文字、图像、视频和代码搜索的研究。
Hugh E. Williams是微软公司华盛顿州雷蒙德总部的Windows Live搜索软件设计工程师。他已经发表了70多篇论文并持有几项专利,其中大部分集中在搜索引擎领域。
  1. Preface
  2. Part I. Introduction
  3. 1. Introduction
  4. Why Is MySQL so Popular?
  5. Elements of MySQL and Its Environment
  6. MySQL Software Covered in This Book
  7. The Book's Web Site
  8. 2. Installing MySQL
  9. Installation Choices and Platforms
  10. Using the Command-Line Interface
  11. Using a Text Editor
  12. Following the Instructions in This Book
  13. Downloading and Verifying Files from the MySQL AB Web Site
  14. Installing Under Linux
  15. Installing Under Windows
  16. Installing Under Mac OS X
  17. Using a MySQL Installation Provided by an ISP
  18. Upgrading an Existing MySQL Server
  19. Configuring Access to the MySQL Server
  20. What If Things Don't Work?
  21. The Contents of the MySQL Directory
  22. Configuring and Controlling the Apache Web Server
  23. Setting up Perl
  24. Resources
  25. Exercises
  26. 3. Using the MySQL Monitor
  27. Starting the Monitor
  28. Style, Case, and Semicolons
  29. The Monitor Help
  30. Running the Monitor in Batch Mode
  31. Loading the Sample Databases
  32. MySQL Monitor Program Options
  33. Graphical Clients
  34. Exercises
  35. Part II. Using MySQL
  36. 4. Modeling and Designing Databases
  37. How Not to Develop a Database
  38. The Database Design Process
  39. The Entity Relationship Model
  40. Entity Relationship Modeling Examples
  41. Using the Entity Relationship Model
  42. Using Tools for Database Design
  43. Resources
  44. Exercises
  45. 5. Basic SQL
  46. Using the Music Database
  47. The SELECT Statement and Basic Querying Techniques
  48. The INSERT Statement
  49. The DELETE Statement
  50. The UPDATE Statement
  51. Exploring Databases and Tables with SHOW and mysqlshow
  52. Exercises
  53. 6. Working with Database Structures
  54. Creating and Using Databases
  55. Creating Tables
  56. The Sample Music Database
  57. Altering Structures
  58. Deleting Structures
  59. Exercises
  60. 7. Advanced Querying
  61. Aliases
  62. Aggregating Data
  63. Advanced Joins
  64. Nested Queries
  65. User Variables
  66. Transactions and Locking
  67. Table Types
  68. Exercises
  69. 8. Doing More with MySQL
  70. Inserting Data Using Queries
  71. Loading Data from Comma-Delimited Files
  72. Writing Data into Comma-Delimited Files
  73. Creating Tables with Queries
  74. Updates and Deletes with Multiple Tables
  75. Replacing Data
  76. The EXPLAIN Statement
  77. Exercises
  78. 9. Managing Users and Privileges
  79. Understanding Users and Privileges
  80. Creating and Using New Users
  81. Privileges
  82. The GRANT OPTION Privilege
  83. How Privileges Interact
  84. Users and Hosts
  85. Checking Privileges
  86. Revoking Privileges
  87. Removing Users
  88. Understanding and Changing Passwords
  89. The Default Users
  90. Devising a User Security Policy
  91. Managing Privileges with SQL
  92. Privileges and Performance
  93. Resetting Forgotten MySQL Passwords
  94. Exercises
  95. Re-Creating Damaged Grant Tables
  96. Resources
  97. Exercises
  98. 11. Using an Options File
  99. Configuring Options for the MySQL Monitor
  100. Structure of the Options File
  101. Scope of Options
  102. Search Order for Options Files
  103. Determining the Options in Effect
  104. Exercises
  105. 12. Configuring and Tuning the Server
  106. The MySQL Server Daemon
  107. Server Variables
  108. Checking Server Settings
  109. Other Things to Consider
  110. Resources
  111. Exercises
  112. Part IV. Web Database Applications with PHP
  113. 13. Web Database Applications
  114. Building a Web Database Application
  115. The Apache Web Server
  116. Introducing PHP
  117. Using a PHP-Enabled Web Hosting Site
  118. Resources
  119. Exercises
  120. 14. PHP
  121. Language Basics
  122. Accessing MySQL Using PHP
  123. Modularizing Code
  124. Processing and Using User Data
  125. The PHP Predefined Superglobal Variables
  126. Untainting User Data
  127. Sessions
  128. The Reload Problem
  129. Using PHP for Command-Line Scripts
  130. Resources
  131. Exercises
  132. 15. A PHP Application: The Wedding Gift Registry
  133. Designing and Creating the Wedding Database
  134. The Login Form
  135. Passing a Message to a Script
  136. Logging Users In and Out
  137. The db.php Include File
  138. Editing the List of Gifts
  139. Loading Sample Gifts
  140. Listing Gifts for Selection
  141. Selecting and Deselecting Gifts
  142. Resources
  143. Exercises
  144. Part V. Interacting with MySQL Using Perl
  145. 16. Perl
  146. Writing Your First Perl Program
  147. Scripting With Perl
  148. Resources
  149. Exercises
  150. 17. Using Perl with MySQL
  151. Connecting to the MySQL Server and Database
  152. Handling Errors When Interacting with the Database
  153. Using Queries That Return Answer Sets
  154. Using Queries That Don't Return Answer Sets
  155. Binding Queries and Variables
  156. Importing and Exporting Data
  157. Handling NULL Values
  158. Resources
  159. Exercises
  160. 18. Serving Perl Pages to the Web
  161. The Perl CGI Module
  162. Processing User Input
  163. A Note on mod_perl
  164. Perl Security
  165. Resources
  166. Exercises
  167. Part VI. Appendix
  168. A. The Wedding Registry Code
  169. Index
书名:学习MySQL(影印版)
国内出版社:东南大学出版社
出版时间:2007年06月
页数:620
书号:978-7-5641-0744-4
原版书出版商:O'Reilly Media
Saied Tahaghoghi
 
Saied Tahaghoghi is a senior lecturer at the RMIT University School of Computer
Science and Information Technology. He has a bachelor's degree in electronics engineering,
a master's degree in computer engineering, and a PhD in computer science,
and loves tinkering with both hardware and software. Saied is a member of the RMIT
Search Engine Group, and supervises research on text, image, video, and code retrieval.
He teaches courses on web technologies and security, and is frequently asked to consult
on projects by industry. Saied was born in Iran but has spent almost equal parts of his
life in Iran, England, Pakistan, and Australia, and is a fervent advocate of dialogue
between civilizations. His home page is http://saied.tahaghoghi.com.
 
 
Hugh E. Williams
 
Hugh E. Williams是澳大利亚墨尔本皇家理工学院计算机科学与IT学校的一个高级讲师,他已有7年的教学经验。目前他主要讲授两个科目:数据库技术和Web技术,他是一个关于Internet和Web技术的主要项目的协调人。他的研究兴趣包括建立更优秀的搜索引擎、生物信息科学和设计更快的数据结构。Hugh业余时间喜欢跑步、看Richmond队的比赛,并且爱好板球。Hugh拥有墨尔本皇家理工学院的博士学位。

Hugh E. Williams是位于澳大利亚墨尔本的RMIT大学计算机科学和IT学院的高级讲师,从1994年起他就在那里教书。他现在所教授的课程包括文件结构与数据库系统、Web数据库应用以及研究方法等。他的研究领域包括建立更好的搜索引擎、生物信息学以及设计更快的数据结构。闲暇时,Hugh喜欢跑步,欣赏Richmond的表演,还喜欢打板球。Hugh取得了RMIT大学的博士学位。
Hugh E. Williams is a software design engineer at Microsoft's Windows Live Search
in Redmond, Washington. Previously, he was an Associate Professor in Information
Retrieval at RMIT University in Melbourne, Australia. He's published over 70 research
papers and holds around 10 patents, mostly in the search engine area. When not at
work, Hugh likes to hang out with his family, exercise, watch Richmond play footy,
and learn about baseball. Hugh has a PhD from RMIT University. His home page is
http://hughwilliams.com.
 
 
The type of butterfly on the cover of Learning MySQL is the blue spotted crow (euploea
midamus). One of more than 15,000 species of butterfly, this member of the brushfooted
family Nymphalidae (which also is home to the Monarch) is native to the Orient
and can be found in a region that spreads from Afghanistan to Australia. As its name
suggests, the crow is distinguished by its blue tint, as well as a series of white spots that
line the hind edge of its large wings.
In the course of their lives, butterflies go through four development stages: egg, larva,
pupa, and adult. Butterfly eggs, ovate or spherical in shape, are attached to leaves by a
powerful, quickly hardening glue until they hatch. In the larval stage, butterflies are
commonly referred to as caterpillars, and their bodies are divided into many small
segments, each possessing up to four pairs of legs. Caterpillars have insatiable appetites,
feeding practically nonstop on plant matter and molting approximately four or five
times before becoming pupae. At this third phase, the caterpillar becomes a chrysalis,
typically cleaving to the underside of a leaf. The chrysalis then consumes foodstuffs
that enable it to develop its wing structures and make the metamorphosis into an adult
butterfly. In this final stage of development, the butterfly is known as an imago, a fourwinged
creature with six legs. Imagos subsist mainly on flower nectar; some supplement
their diets with nutrients from sap, pollen, rotten fruit, or dung.
In Japanese culture, butterflies are somewhat paradoxically mythologized as both harbingers
of prosperity and impending doom. One superstition stipulates that a single
butterfly flying into one's bedroom presages the arrival of one's dearest love, while an
encounter with a swarm of butterflies is thought to be a precursor to ominous events.