作者:Rick F. van der Lans
出版日期:April 30, 2007
出版社:Addison Wesley
页数:1032
ISBN:ISBN-10: 0131497359 ISBN-13: 978-0131497351
文件格式:PDF
Product Description
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect
MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers,Rick F. van der Lans helps you master this version ofSQL and takeadvantage of its full potential. Using case study examplesand hands-onexercises, van der Lans illuminates every key concept,technique, andstatement–including advanced features that make iteasier to create eventhe most complex statements and programs.
Drawing on decades of experience as an SQLstandards team member and enterprise consultant, he reveals exactly whyMySQL’s dialect works as it does–and how to get the most out of it.You’ll gain powerful insight into everything from basic queries tostored procedures, transactions to data security.
Whether you’re a programmer, Web developer,analyst, DBA, or database user, this book can take you from“apprentice” to true SQL expert. If you’ve used SQL in older versionsof MySQL, you’ll become dramatically more effective–and if you’remigrating from other database platforms, you’ll gain practical mastery fast.
Coverage includes
Writing queries, including joins, functions, and subqueriesUpdating dataCreating tables, views, and other database objectsSpecifying keys and other integrity constraintsImproving efficiency with indexesEnforcing security via passwords and privilegesEmbedding SQL statements within PHP programsBuilding stored procedures and triggersUsing transactions, locking, rollback, and isolation levelsUtilizing MySQL’s catalogAll of the book’s sample programs are available for download from www.r20.nl.
About the Author
Rick F. van der Lans is author of the classic Introduction to SQL,the definitive SQL guide that database developers have relied on formore than 20 years. He is a consultant, author, and lecturerspecializing in database technology, development tools, datawarehousing, and XML. As managing director of the Netherlands-basedR20/Consultancy, he has advised many large companies on defining theirIT architectures. He chairs the European Meta Data Conference, andwrites columns for several magazines.