MySQL Cookbook.

Format:

Book

Author/Creator:

Dubois, Paul.

Language:

English

Subjects (All):

MySQL (Electronic resource).

Database management.

Relational databases.

SQL (Computer program language).

Local Subjects:

Database management.

Relational databases.

SQL (Computer program language).

Physical Description:

1 online resource (988 p.)

Edition:

2nd ed.

Other Title:

My SQL cookbook

Place of Publication:

Sebastopol : O'Reilly Media, 2006.

Language Note:

English

System Details:

text file

Summary:

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 worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formu

Contents:

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

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

Description based on publisher supplied metadata and other sources.

ISBN:

9781449338848

1449338844

9780596515478

0596515472

OCLC:

85872816