MySQLCookbook3rdEdition

MySQL

1星需积分: 9 81 浏览量更新于2023-03-16 评论收藏 2.14MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

DATABASES

MySQL Cookbook

ISBN: 978-1-449-37402-0

US $79.99 CAN $83.99

“

A true classic, this remains

the best collection of

MySQL recipes available.

This book covers basics

needed by beginners,

and presents the very

latest developments that

advanced users can use

to deepen their knowledge.

And it’s crowded with

tips that make it even

more valuable to MySQL

professionals.

”

—Ulf Wendel,

Senior Software Engineer for MySQL and

co-author of the mysqlnd PHP library

Twitter: @oreillymedia

facebook.com/oreilly

MySQL’s popularity has brought a flood of questions about how to solve

specific problems, and that’s where this cookbook is essential. When you

need quick solutions or techniques, this handy resource provides scores

of short, focused pieces of code, hundreds of worked-out examples, and

clear, concise explanations for programmers who don’t have the time (or

expertise) to solve MySQL problems from scratch.

Ideal for beginners and professional database and web developers, this

updated third edition covers powerful features in MySQL 5.6 (and some

in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl,

and Ruby. With more than 200+ recipes, you’ll learn how to:

■ Use the mysql client and write MySQL-based programs

■ Create, populate, and select data from tables

■ Store, retrieve, and manipulate strings

■ Work with dates and times

■ Sort query results and generate summaries

■ Use stored routines, triggers, and scheduled events

■ Import, export, validate, and reformat data

■ Perform transactions and work with statistics

■ Process web input, and generate web content from

query results

■ Use MySQL-based web session management

■ Provide security and server administration

Paul DuBois is one of the primary contributors to the MySQL Reference Manual,

a renowned online manual that has supported MySQL administrators and

database developers for years. He’s a member of the MySQL documentation

team at Oracle and author of several books.

MySQL Cookbook

THIRD EDITION

DuBois

Paul DuBois

M y S Q L

Cookbook

SOLUTIONS FOR DATABASE DEVELOPERS AND ADMINISTRATORS

3rd Edition

Revised and Updated

www.it-ebooks.info

DATABASES

MySQL Cookbook

ISBN: 978-1-449-37402-0

US $79.99 CAN $83.99

“

A true classic, this remains

the best collection of

MySQL recipes available.

This book covers basics

needed by beginners,

and presents the very

latest developments that

advanced users can use

to deepen their knowledge.

And it’s crowded with

tips that make it even

more valuable to MySQL

professionals.

”

—Ulf Wendel,

Senior Software Engineer for MySQL and

co-author of the mysqlnd PHP library

Twitter: @oreillymedia

facebook.com/oreilly

MySQL’s popularity has brought a flood of questions about how to solve

specific problems, and that’s where this cookbook is essential. When you

need quick solutions or techniques, this handy resource provides scores

of short, focused pieces of code, hundreds of worked-out examples, and

clear, concise explanations for programmers who don’t have the time (or

expertise) to solve MySQL problems from scratch.

Ideal for beginners and professional database and web developers, this

updated third edition covers powerful features in MySQL 5.6 (and some

in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl,

and Ruby. With more than 200+ recipes, you’ll learn how to:

■ Use the mysql client and write MySQL-based programs

■ Create, populate, and select data from tables

■ Store, retrieve, and manipulate strings

■ Work with dates and times

■ Sort query results and generate summaries

■ Use stored routines, triggers, and scheduled events

■ Import, export, validate, and reformat data

■ Perform transactions and work with statistics

■ Process web input, and generate web content from

query results

■ Use MySQL-based web session management

■ Provide security and server administration

Paul DuBois is one of the primary contributors to the MySQL Reference Manual,

a renowned online manual that has supported MySQL administrators and

database developers for years. He’s a member of the MySQL documentation

team at Oracle and author of several books.

MySQL Cookbook

THIRD EDITION

DuBois

Paul DuBois

M y S Q L

Cookbook

SOLUTIONS FOR DATABASE DEVELOPERS AND ADMINISTRATORS

3rd Edition

Revised and Updated

www.it-ebooks.info

Table of Contents

Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi

1. Using the mysql Client Program. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

1.1. Setting Up a MySQL User Account 2

1.2. Creating a Database and a Sample Table 4

1.3. What to Do if mysql Cannot Be Found 6

1.4. Specifying mysql Command Options 8

1.5. Executing SQL Statements Interactively 13

1.6. Executing SQL Statements Read from a File or Program 15

1.7. Controlling mysql Output Destination and Format 17

1.8. Using User-Defined Variables in SQL Statements 22

2. Writing MySQL-Based Programs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

2.1. Connecting, Selecting a Database, and Disconnecting 29

2.2. Checking for Errors 42

2.3. Writing Library Files 51

2.4. Executing Statements and Retrieving Results 65

2.5. Handling Special Characters and NULL Values in Statements 79

2.6. Handling Special Characters in Identifiers 89

2.7. Identifying NULL Values in Result Sets 91

2.8. Techniques for Obtaining Connection Parameters 95

2.9. Conclusion and Words of Advice 103

3. Selecting Data from Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105

3.1. Specifying Which Columns and Rows to Select 106

3.2. Naming Query Result Columns 108

3.3. Sorting Query Results 112

3.4. Removing Duplicate Rows 113

3.5. Working with NULL Values 114

iii

www.it-ebooks.info

剩余99页未读，继续阅读

philosopher2007

2020-03-11

别下，只有100页

csdn5920

粉丝: 0
资源: 3

会员权益专享

MySQL Cookbook 3rd Edition

评论1

会员权益专享

最新资源

MySQL Cookbook 3rd Edition

评论1

Django 2 Web Development Cookbook 3rd Edition.pdf

Active Directory Cookbook, 3rd Edition.pdf

Embedded Linux Development Using Yocto Project Cookbook Second Edition

OpenCV Computer Vision Application Programming Cookbook Second Edition.pdf

Yii Application Development Cookbook Second Edition

Node Cookbook, Second Edition.pdf

Windows PowerShell Cookbook(3rd) 无水印pdf

OpenCV Computer Vision Application Programming Cookbook Second Edition

Linux Shell Scripting Cookbook Third Edition

Practical Linux Security Cookbook 2nd Edition

Microsoft Exchange Server PowerShell Cookbook(3rd) 无水印原版pdf

OpenCV 3 Computer Vision Application Programming Cookbook(3rd) 无水印pdf

Kali Linux Cookbook - Second Edition.pdf

758820 mysql 8 cookbook(中文版)

闭环buck电路设计参考资料

javascript $.each用法例子

会员权益专享

最新资源