Js editor

Visual Quickstart Guide MySQL

Chapter I.  Introduction       What Is MySQL?       MySQL Versions       Primary MySQL Resources       Technical Requirements       About This Book       Is This Book for You?       Companion Web Site       Questions, Comments, or Suggestions?     Chapter 1.  Installing MySQL       General Installation Steps       Installing MySQL on Windows       Configuring MySQL on Windows       Installing MySQL on Macintosh       Installing MySQL on Linux       Basic Configuration Options       Upgrading MySQL     Chapter 2.  Running MySQL       Running MySQL on Windows and Windows NT       Running MySQL on Mac OS X       Running MySQL on Linux and Unix       Using Mysqladmin       Setting the Root User Password       Using the Mysql Client       Users and Privileges     Chapter 3.  Database Design       Normalization       Understanding Keys       Understanding Relationships       First Normal Form       Second Normal Form       Third Normal Form     Chapter 4.  Creating a MySQL Database       MySQL Data Types       Extra Column Characteristics       Introduction to Indexes       Finalizing a Table's Design       Choosing a Storage Engine       Character Sets and Collations       Creating Databases       Creating Tables       Modifying Tables     Chapter 5.  Basic SQL       Using Values in Queries       Inserting Data       Selecting Data       Using Conditionals       Using LIKE and NOT LIKE       Performing Joins       Sorting Query Results       Limiting Query Results       Updating Data       Deleting Data     Chapter 6.  MySQL Functions       Text Functions       Concatenation and Aliases       Numeric Functions     Chapter 7.  MySQL and PHP       Connecting to MySQL and Selecting a Database       Executing Simple Queries       Retrieving Query Results       Using mysqli_insert_id()       Error Handling       Security Considerations     Chapter 8.  MySQL and Perl       Installing Perl with MySQL Support on Windows       Installing Perl Support for MySQL on Unix and Mac OS X       Testing Perl and MySQL       Connecting to MySQL       Retrieving Query Results       Executing Simple Queries       Retrieving the Insert ID       Error Handling       Security Considerations       Using Prepared Statements     Chapter 9.  MySQL and Java       Installing Java Support for MySQL       Connecting to the Database       Executing Simple Queries       Retrieving Query Results       Retrieving the Insert ID       Using Prepared Statements     Chapter 10.  Advanced SQL and MySQL       Performing Transactions       Full-Text Searching       Regular Expressions       User-Defined Variables       Introducing Unions     Chapter 11.  MySQL 5 Features       Stored Routines       Using OUT Parameters       Triggers       Views     Chapter 12.  Techniques for Programming       Storing and Retrieving Binary Data       Making Query Result Pages       Using Transactions with Perl     Chapter 13.  MySQL Administration       The MySQL Administrator       Backing Up Databases       Importing Data       MySQL Logging       Database Maintenance       Improving Performance       Using Batch Files     Appendix A.  Troubleshooting       Installation       Starting MySQL       Accessing MySQL       mysql.sock Problems       Queries That Return Strange Results       Authentication Protocol Problems       Resetting the Root Password     Appendix B.  SQL and MySQL References       Basic SQL       ALTER Commands       SQL Clauses       MySQL Privileges       MySQL Data Types       MySQL Functions       Other References     Appendix C.  Resources       MySQL-Specific       Third-Party MySQL Applications       SQL       PHP       Perl       Java       Other     Index

Js editor