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