Section 1.2. Setting Up a MySQL User Account
Section 1.3. Creating a Database and a Sample Table
Section 1.4. Starting and Terminating mysql
Section 1.5. Specifying Connection Parameters by Using Option Files
Section 1.6. Protecting Option Files
Section 1.7. Mixing Command-Line and Option File Parameters
Section 1.8. What to Do if mysql Cannot Be Found
Section 1.9. Setting Environment Variables
Section 1.10. Issuing Queries
Section 1.11. Selecting a Database
Section 1.12. Canceling a Partially Entered Query
Section 1.13. Repeating and Editing Queries
Section 1.14. Using Auto-Completion for Database and Table Names
Section 1.15. Using SQL Variables in Queries
Section 1.16. Telling mysql to Read Queries from a File
Section 1.17. Telling mysql to Read Queries from Other Programs
Section 1.18. Specifying Queries on the Command Line
Section 1.19. Using Copy and Paste as a mysql Input Source
Section 1.20. Preventing Query Output from Scrolling off the Screen
Section 1.21. Sending Query Output to a File or to a Program
Section 1.22. Selecting Tabular or Tab-Delimited Query Output Format
Section 1.23. Specifying Arbitrary Output Column Delimiters
Section 1.24. Producing HTML Output
Section 1.25. Producing XML Output
Section 1.26. Suppressing Column Headings in Query Output
Section 1.27. Numbering Query Output Lines
Section 1.28. Making Long Output Lines More Readable
Section 1.29. Controlling mysql's Verbosity Level
Section 1.30. Logging Interactive mysql Sessions
Section 1.31. Creating mysql Scripts from Previously Executed Queries
Section 1.32. Using mysql as a Calculator
Section 1.33. Using mysql in Shell Scripts