- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
Full Description
This book describes MYSQL's SQL dialect. It teaches how and why to use certain features of the language. Not only the classic features of SQL are described, but also the more advanced features. Every aspect of the language is discussed thoroughly and critically. The following aspects of SQL, among other things, are covered: Querying and updating data (joins, functions, and subqueries), creating tables, specifying primary and foreign keys and other constraints, using indexes, data security, developing stored procedures and triggers. Application development with PHP and Python, transactions, optimization of statements, is also discussed. Many users of MySQL have only very limited knowledge of SQL and would be significantly more productive if they had a better understanding of SQL. Others know SQL, but are unfamiliar with the idiosyncracies of MySQL's SQL implementation. In either case, this is the book for them. The exercises are a key benefit for readers familiar with other SQL variants. The structure, style and approach of this book is based on van der Lans best-selling Introduction to SQL (published by Addison-Wesley since 1987). This book is still being used at many universities, and is now in a fourth edition. And that structure and approach have therefore been tested over and over again.
Contents
About the Author xixPreface xxPART I Introduction 1CHAPTER 1 Introduction to MySQL 3CHAPTER 2 The Tennis Club Sample Database 29CHAPTER 3 Installing the Software 37CHAPTER 4 SQL in a Nutshell 41PART II Querying and Updating Data 71CHAPTER 5 SELECT Statement: Common Elements 73CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries 145CHAPTER 7 SELECT Statement:The FROM Clause 171CHAPTER 8 SELECT Statement: The WHERE Clause 213CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions 315CHAPTER 10 SELECT Statement: The GROUP BY Clause 349CHAPTER 11 SELECT Statement: The HAVING Clause 375CHAPTER 12 SELECT Statement: The ORDER BY Clause 383CHAPTER 13 SELECT Statement: The LIMIT Clause 395CHAPTER 14 Combining Table Expressions 409CHAPTER 15 The User Variable and the SET Statement 421CHAPTER 16 The HANDLER Statement 429CHAPTER 17 Updating Tables 437CHAPTER 18 Loading and Unloading Data 461CHAPTER 19 Working with XML Documents 471PART III Creating Database Objects 491CHAPTER 20 Creating Tables 493CHAPTER 21 Specifying Integrity Constraints 539CHAPTER 22 Character Sets and Collations 561CHAPTER 23 The ENUM and SET Types 577CHAPTER 24 Changing and Dropping Tables 591CHAPTER 25 Using Indexes 603CHAPTER 26 Views 631CHAPTER 27 Creating Databases 653CHAPTER 28 Users and Data Security 659CHAPTER 29 Statements for Table Maintenance 683CHAPTER 30 The SHOW, DESCRIBE, and HELP Statements 693PART IV Procedural Database Objects 701CHAPTER 31 Stored Procedures 703CHAPTER 32 Stored Functions 745CHAPTER 33 Triggers 755CHAPTER 34 Events 767PART V Programming with SQL 783CHAPTER 35 MySQL and PHP 785CHAPTER 36 Dynamic SQL with Prepared Statement 807CHAPTER 37 Transactions and Multiuser Usage 815APPENDIX A Syntax of SQL 839APPENDIX B Scalar Functions 903APPENDIX C System Variables 953APPENDIX D Bibliography 963Index 967
