7.1. How a MySQL Database Works7.1.1. Communicating with the MySQL Server7.1.2. The Database Structure7.1.3. The SQL Language7.1.4. Sending a Query to the MySQL Server7.1.5. Database Security7.1.6. MySQL Versions7.2. Send a Query with the mysql Client7.2.1. Send a Query with the mysql Client7.3. Send a Query with the MySQL Query Browser7.3.1. Send a Query with the MySQL Query Browser7.4. Create, Select, or Remove a MySQL Database7.4.1. Create, Select, or Remove a MySQL Database7.4.1.1. LIST THE DATABASES7.4.1.2. CREATE AN ERROR7.4.1.3. CREATE A DATABASE7.4.1.4. SELECT A DATABASE7.4.1.5. REMOVE A DATABASE7.5. Define a MySQL Table7.5.1. Table and Column Names7.5.2. Data Types7.5.3. The Primary Key7.5.4. Auto-Increment Columns7.5.5. Negative Numbers7.5.6. Defaults7.5.7. Empty Columns7.5.8. Relationships between Tables7.6. Create and Remove a MySQL Table7.6.1. Create and Remove a MySQL Table7.6.1.1. CREATE A TABLE7.6.1.2. REMOVE A TABLE7.7. Modify the MySQL Table Structure7.7.1. Modify the MySQL Table Structure7.8. Add a Row of Data to a Database7.8.1. Add a Row of Data to a Database7.9. Add Data from a Text File to a Database7.9.1. Add Data from a Text File to a Database7.10. Store Incremental Values in a Column7.10.1. Store Incremental Values in a Column7.11. Retrieve Data from a Database7.11.1. Retrieve Data from a Database7.12. Limit Query Execution to Specific Rows with a WHERE Clause7.12.1. Limit Query Execution to Specific Rows with a WHERE Clause7.13. Retrieve Data from Multiple Tables with UNION7.13.1. Retrieve Data from Multiple Tables with UNION7.14. Retrieve Data from Multiple Tables by Joining Tables7.14.1. Retrieve Data from Multiple Tables by Joining Tables7.15. Update Data in a Database7.15.1. Update Data in a Database7.16. Remove Data from a Database7.16.1. Remove Data from a Database7.17. Query a MySQL Database from a PHP Script7.17.1. Query a MySQL Database from a PHP Script7.18. Display Database Data on a Web Page in a PHP Script7.18.1. Display Database Data on a Web Page in a PHP Script7.19. Handle MySQL Errors7.19.1. Handle MySQL Errors