MySQL Cookbook
Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worke...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly Media
2006.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627197506719 |
Tabla de Contenidos:
- MySQL Cookbook; MySQL Cookbook; Table of Contents; Preface; Who This Book Is For; What's in This Book; MySQL APIs Used in This Book; Conventions Used in This Book; The MySQL Cookbook Companion Web Site; Version and Platform Notes; Upgrade Note for First Edition Readers; Additional Resources; Using Code Examples; Safari® Enabled; How to Contact Us; Acknowledgments; Second Edition; First Edition; Chapter 1. Using the mysql Client Program; 1.0 Introduction; 1.1 Setting Up a MySQL User Account; Problem; Solution; Discussion; 1.2 Creating a Database and a Sample Table; Problem; Solution
- Discussion1.3 Starting and Stopping mysql; Problem; Solution; Discussion; 1.4 Specifying Connection Parameters Using Option Files; Problem; Solution; Discussion; 1.5 Protecting Option Files from Other Users; Problem; Solution; Discussion; 1.6 Mixing Command-Line and Option File Parameters; Problem; Solution; Discussion; 1.7 What to Do if mysql Cannot Be Found; Problem; Solution; Discussion; 1.8 Issuing SQL Statements; Problem; Solution; Discussion; See Also; 1.9 Canceling a Partially Entered Statement; Problem; Solution; Discussion; 1.10 Repeating and Editing SQL Statements; Problem
- SolutionDiscussion; 1.11 Using Auto-Completion for Database and Table Names; Problem; Solution; Discussion; 1.12 Telling mysql to Read Statements from a File; Problem; Solution; Discussion; 1.13 Telling mysql to Read Statements from Other Programs; Problem; Solution; Discussion; See Also; 1.14 Entering an SQL One-Liner; Problem; Solution; Discussion; 1.15 Using Copy and Paste as a mysql Input Source; Problem; Solution; Discussion; 1.16 Preventing Query Output from Scrolling off the Screen; Problem; Solution; Discussion; 1.17 Sending Query Output to a File or to a Program; Problem
- SolutionDiscussion; 1.18 Selecting Tabular or Tab-Delimited Query Output Format; Problem; Solution; Discussion; 1.19 Specifying Arbitrary Output Column Delimiters; Problem; Solution; Discussion; See Also; 1.20 Producing HTML or XML Output; Problem; Solution; Discussion; See Also; 1.21 Suppressing Column Headings in Query Output; Problem; Solution; Discussion; 1.22 Making Long Output Lines More Readable; Problem; Solution; Discussion; 1.23 Controlling mysql's Verbosity Level; Problem; Solution; Discussion; 1.24 Logging Interactive mysql Sessions; Problem; Solution; Discussion
- 1.25 Creating mysql Scripts from Previously Executed StatementsProblem; Solution; Discussion; 1.26 Using User-Defined Variables in SQL Statements; Problem; Solution; Discussion; 1.27 Numbering Query Output Lines; Problem; Solution; Discussion; 1.28 Using mysql as a Calculator; Problem; Solution; Discussion; 1.29 Using mysql in Shell Scripts; Problem; Solution; Discussion; Writing shell scripts under Unix; Writing shell scripts under Windows; Chapter 2. Writing MySQL-Based Programs; 2.0 Introduction; Assumptions; MySQL Client API Architecture
- 2.1 Connecting, Selecting a Database, and Disconnecting
