MySQL 5.x offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version of SQL, and leverage its full potential. Using case study examples and hands-on exercises, van der Lans illuminates every key concept, technique, and statement-including advanced features that make it easier to create even the most complex statements and programs. Drawing on decades of experience as a SQL standards team member and enterprise consultant, he reveals exactly why MySQL'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 to stored 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 versions of MySQL, you'll become dramatically more effective-and if you're migrating from other database platforms, you'll gain practical mastery fast.· Writing queries, including joins, functions, and subqueries· Updating data· Creating tables, views, and other database objects· Specifying keys and other integrity constraints· Improving efficiency with indexes· Enforcing security via passwords and privileges· Building stored procedures and triggers· Embedding SQL statements within PHP programs· Using transactions, savepoint, rollback, isolation level, and repeatable read· Optimizing performance by reformulating SQL statements· Utilizing MySQL's catalog· Reference section: SQL statement definitions and SQL function lists

MySQL 5.x提供了一种具有巨大力量的SQL方言。在《SQL for MySQL Developers》中，Rick F. van der Lans帮助你掌握这一版本的SQL，并充分利用其全部潜力。通过使用案例研究和实践练习，van der Lans阐明了每一个关键的概念、技术和语句--包括使创建最复杂的语句和程序更容易的高级功能。凭借数十年来作为SQL标准团队成员和企业顾问的经验，他准确地揭示了MySQL方言工作的原因，以及如何最大限度地利用它。无论你是程序员、Web开发人员、分析师、DBA还是数据库用户，这本书都能让你从 "学徒 "变成真正的SQL专家，你将获得强大的洞察力。如果你在旧版本的MySQL中使用过SQL，你会变得更加有效--如果你从其他数据库平台迁移过来，你会迅速获得实用的掌握。 - 编写查询，包括连接、函数和子查询--更新数据--创建表、视图和其他数据库对象--指定键和其他完整性约束--用索引提高效率--通过密码和权限执行安全--建立存储过程和触发器--在PHP程序中嵌入SQL语句--使用事务、保存点、回滚、隔离级别和可重复读取--通过重新制定SQL语句优化性能--利用MySQL的目录--参考部分。SQL语句定义和SQL函数列表