Beginning MySQL

Robert Sheldon, Geoff Moes

  • 出版商: Wrox Press
  • 出版日期: 2005-04-01
  • 售價: $2,030
  • 貴賓價: 9.5$1,929
  • 語言: 英文
  • 頁數: 864
  • 裝訂: Paperback
  • ISBN: 0764579509
  • ISBN-13: 9780764579509
  • 相關分類: MySQLSQL
  • 下單後立即進貨 (約1~3週)




  • 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)


    Table of Contents:



    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.