|
Beginning MySQL
* Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information
* Offers detailed instructions for MySQL installation and configuration on either Windows or Linux
* Shows how to create
a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications
* Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications
* Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)
Acknowledgments.
Introduction.
Chapter 1: Introducing the MySQL Relational Database Management System.
Chapter 2: Installing MySQL.
Chapter 3: Working with MySQL.
Chapter 4: Designing a Relational Database.
Chapter 5: Managing Databases, Tables, and Indexes.
Chapter 6: Manipulating Data in a MySQL Database.
Chapter 7: Retrieving Data from a MySQL Database.
Chapter 8: Using Operators in Your SQL Statements.
Chapter 9: Using Functions in Your SQL Statements.
Chapter 10: Accessing Data in Multiple Tables.
Chapter 11: Exporting, Copying, and Importing Data.
Chapter 12: Managing Transactions.
Chapter 13: Administering MySQL.
Chapter 14: Managing MySQL Security.
Chapter 15: Optimizing Performance.
Chapter 16: Managing Backup, Recovery, and Replication.
Chapter 17: Connecting to MySQL from a PHP Application.
Chapter 18: Connecting to MySQL from a Java/J2EE Application.
Chapter 19: Connecting to MySQL from an ASP.NET/C# Application.
Appendix A: Exercise Answers.
Appendix B: MySQL APIs.
Appendix C: MySQL 5.
Stored Procedures.
Triggers.
Views.
Index.
|
