MySQL Cookbook
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. 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).
|
Contents
|
Chapter 1 Using the mysql Client Program
|
1 |
|
Chapter 2 Writing MySQLBased Programs
|
25 |
|
Chapter 3 Selecting Data from Tables
|
105 |
|
Chapter 4 Table Management
|
127 |
|
Chapter 5 Working with Strings
|
139 |
|
Chapter 6 Working with Dates and Times
|
179 |
|
Chapter 7 Sorting Query Results
|
233 |
|
Chapter 8 Generating Summaries
|
271 |
|
Chapter 14 Using Joins and Subqueries
|
473 |
|
Chapter 15 Statistical Techniques
|
511 |
|
Chapter 16 Handling Duplicates
|
549 |
|
Chapter 17 Performing Transactions
|
565 |
|
Chapter 18 Introduction to MySQL on the Web
|
577 |
|
Chapter 19 Generating Web Content from Query Results
|
605 |
|
Chapter 20 Processing Web Input with MySQL
|
647 |
|
Chapter 21 Using MySQLBased Web Session Management
|
725 |
|
Chapter 9 Using Stored Routines Triggers and Scheduled Events
|
307 |
|
Chapter 10 Working with Metadata
|
335 |
|
Chapter 11 Importing and Exporting Data
|
367 |
|
Chapter 12 Validating and Reformatting Data
|
409 |
|
Chapter 13 Generating and Using Sequences
|
445 |
Common terms and phrases
array AUTO_INCREMENT binary CGI.pm chapter character set clause client collation column names column values command line connection contains convert cookbook CREATE TABLE data types data values database datafile default Discussion display driver_log duplicate enable encoding error example execute format function hash INNER JOIN InnoDB input INSERT invoke Java JDBC JSTL library file LOAD DATA localhost match metadata method module MyISAM MySQL server NULL values option file ORDER output parameters password pattern matches Perl Perl DBI placeholders plug-in PRIMARY KEY printf Problem You want produce Python query result recipes distribution regular expressions result set retrieve returns Ruby script SELECT name sequence session Solution sort specify SQL statements srcuser stmt stored string tags tbl_name TIMESTAMP Tomcat tricia undef Unix UPDATE variable web server write