Beginning Mysql

0.0

Beginning MySQL provides programmers a complete foundation in MySQL including: detailed instructions on installation for both a Windows and Linux platform, implementation, how to create a database, add data to the database, query and modify that data, and build applications that access the data. Once programmers have been provided a solid foundation in MySQL and SQL, they learn how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications. SQL is covered in detail as it is implemented in MySQL, and with a cohesive overview of the language. By the end of the book, the beginning MySQL user will have installed MySQL, configured it, created a database and its tables, added data to the database and manipulated that data, performed administrative tasks, and created applications that access the data in the database. About The Author Robert Sheldon is an experienced MySQL programmer with extensive experience working with SQL in MySQL, SQL Server, Access, and Oracle environments. Geoff Moes is a software architect and developer who has designed and implemented databases in MySQL as well as having designed and implemented software systems in PHP, Java/J2EE and ASP.NET that have utilized MySQL databases. Table Of Contents Acknowledgments Introduction Introducing the MySQL Relational Database Management System Installing MySQL Working with MySQL Designing a Relational Database Managing Databases, Tables, and Indexes Manipulating Data in a MySQL Database Retrieving Data from a MySQL Database Using Operators in Your SQL Statements Using Functions in Your SQL Statements Accessing Data in Multiple Tables Exporting, Copying, and Importing Data Managing Transactions Administering MySQL Managing MySQL Security Optimizing Performance Managing Backup, Recovery, and Replication Connecting to MySQL from a PHP Application Connecting to MySQL from a Java/J2EE Application Connecting to MySQL from an ASP.NET/C# Application Appendix Appendix A: Exercise Answers Appendix B: MySQL APIs Appendix C: MySQL 5 Stored Procedures Triggers Views Index