買這商品的人也買了...
-
$998Fundamentals of Data Structures in C++
-
$580$458 -
$2,400$2,280 -
$650$553 -
$980$774 -
$1,150$1,127 -
$1,670$1,587 -
$998Operating System Concepts, 6/e (Windows XP Update)
-
$860$731 -
$1,030$1,009 -
$1,600$1,568 -
$780$741 -
$590$466 -
$690$538 -
$780$663 -
$620$490 -
$990$782 -
$580$493 -
$750$675 -
$560$504 -
$390$304 -
$480$379 -
$780$741 -
$550$468 -
$580$493
商品描述
MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.
The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:
- Import data from external sources
- Export data for use by external programs
- Access MySQL from your web server
- Use scripts with MySQL to read queries from a file
- Access MySQL from within client programs that use Perl, PHP, Java, Python
and other languages
- Construct queries that solve commonly-occurring questions
- Interact with the server
This learn-as-you-go resource will help users of all levels exploit MySQL
more fully. MySQL Cookbook supplies you with an armory of ready-made
techniques for specific problems so that, even if you're an experienced MySQL
user, you don't have to write everything from scratch.
Table of Contents
Preface
1. Using the mysql Client Program
2. Writing MySQL-Based Programs
3. Record Selection Techniques
4. Working with Strings
5. Working with Dates and Times
6. Sorting Query Results
7. Generating Summaries
8. Modifying Tables with ALTER TABLE
9. Obtaining and Using Metadata
10. Importing and Exporting Data
11. Generating and Using Sequences
12. Using Multiple Tables
13. Statistical Techniques
14. Handling Duplicates
15. Performing Transactions
16. Introduction to MySQL on the Web
17. Incorporating Query Results into Web Pages
18. Processing Web Input with MySQL
19. Using MySQL-Based Web Session Management
A. Obtaining MySQL Software
B. JSP and Tomcat Primer
C. References
Index