MySQL Cookbook Free Open Book

MySQL Cookbook

SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

C API 
    option files, support for 
<c:out> tag (JSTL) 
<\\c:url> tag (JSTL)> 
calculated values, sorting by 
calculations, using mysql to evaluate 
calendar order 
cascaded deletes 
    LEFT JOINs, for deleting childless parent records 
case and sorting 
case sensitivity
    ENUM columns 
    hash lookups, Perl 
    HTML 
    MIN( ) and MAX( ), control of while using 
    pattern matching and 
    XML 
CAST( ) 
Catalina 
cgi-bin directory 
    language neutrality 
cgi.escape( ) (Python) 
CGI.pm
    default form initialization behavior 
    file upload parameter 
CHANGE keyword 
CHAR columns, conversion to VARCHAR types 
character columns, conversion from fixed-length to variable-length types 
check_enum_value( ) 
check_set_value( ) 
checkbox_group( ) (Perl) 
checkboxes 
chmod command 
click to sort headings, query results tables 
clickable hyperlinks, generating from query results 
clicksort.php 
client library 
client-server architecture 
client-server protocol 
clients  [See also mysql]2nd  3rd 
    accounts, creating 
    APIs 
        capabilities 
    finding out whoÕs connected 
    sequences, retrieving on 
        server-side retrieval, compared to 
cmdline.java 
cmdline.pl 
    problems with 
cmdline.py 
code reuse 
column definitions
    files for ALTER TABLE statements 
    NULL and default value attributes, impact on 
column types  2nd 
    AUTO_INCREMENT columns, integer types requirement 
    date and time 
        DATE 
        DATETIME  2nd 
        functions used on 
        TIME  2nd 
    TIMESTAMP  2nd 
        first in record 
        records, creation and modification time 
columns
    adding to tables 
    aliases 
        as input columns in queries 
        column concatenation and 
        joins and 
        using in programs 
    BINARY type, case sensitivity 
    character conversion from fixed-length to variable-length types 
    combining to construct composite values 
    default values 
    displaying 
        with column name aliases 
        order, control of 
    dropping from tables 
    extraction, rearranging 
    indexes, numbering 
    lists, displaying using table information 
    LONGBLOB 
    MEDIUMBLOB 
    metadata, getting for 
    moving in tables 
    names, quoting in pattern strings 
    non-unique column names, handling in result sets 
    NULL values and empty fields, distinguishing 
    renaming 
    selection of all but a few 
    specifying input order in data loads 
    trailing spaces, preserving in string columns 
    types
        case sensitivity of 
        changing 
        mapping to web page elements 
combine( ) (Perl) 
comma-separated values file format  [See CSV]
ÒCommand not foundÓ error 
command-line options  [See options]
COMMIT statement 
communications protocols and APIs 
comparison operators
    for NULL values 
        in records 
    JSTL 
    strings, using on 
component extraction functions, using for decomposing dates and times 
computed summaries  [See also summaries]2nd 
CONCAT( )  2nd  3rd  4th 
    MAX-CONCAT trick 
    single strings, representing multiple column values as 
configuration variables, for specifying library file locations 
connect( ) (Java), implementing from library file 
connect( ) (Perl) 
    arguments 
connect( ) (PHP MySQL_Access class) 
connect( ) (Python) 
Connect.java 
connect.php
    testing 
connect.pl 
connect.py 
connection parameters 
    obtaining 
        from option files 
        Java  2nd 
        Perl  2nd 
        PHP  2nd 
        Python 
    option files, specifying with 
connection parameters, obtaining
    Python
        from option files 
content-type headers 
<Context> elements 
cookbook_connect( ) (PHP) 
Cookbook_DB_Access class (PHP)  2nd 
cookies 
    PERLSESSID 
correlation coefficients, calculating 
COUNT( ) 
    COUNT(*) and COUNT(expr) 
    IF( ) and 
    NULL values and 
    speed on different table types 
    WHERE clauses and 
count( ) PHP
    column counts and 
COUNT(*)
    avoiding errors using 
COUNT(DISTINCT) 
    NULLs, including in a count 
count_rows.sh 
counting summaries  [See also summaries]2nd  3rd 
CPAN (Comprehensive Perl Archive Network) 
CREATE DATABASE statement 
CREATE INDEX statement 
CREATE TABLE ... SELECT statement 
CREATE TABLE statement  2nd 
    AUTO_INCREMENT columns, including 
    multi-column PRIMARY KEYs, creating tables with 
    specifying transactional type 
    table structure, getting with 
CREATE TEMPORARY TABLE statement  2nd 
credit card numbers, pattern for matching 
csh
    PATH environment variable, setting 
CSV (comma-separated values) file format  2nd 
CSV (comma-separated values) format, converting output to 
cumulative sums, finding using self-joins 
CURDATE( )  2nd  3rd  4th 
current date or time, determining 
cursors
    MySQL and 
CURTIME( ) 
CustomLog directives  2nd 
cut utility 
cvt_date.pl 
cvt_file.pl 
    options 
cycles, generating 
Cygwin (Cygnus tools for Windows) 

Index: [SYMBOL][A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X][Y][Z]


     Main Menu
Main Page
Table of content
Copyright
Preface
Chapter 1. Using the mysql Client Program
Chapter 2. Writing MySQL-Based Programs
Chapter 3. Record Selection Techniques
Chapter 4. Working with Strings
Chapter 5. Working with Dates and Times
Chapter 6. Sorting Query Results
Chapter 7. Generating Summaries
Chapter 8. Modifying Tables with ALTER TABLE
Chapter 9. Obtaining and Using Metadata
Chapter 10. Importing and Exporting Data
Chapter 11. Generating and Using Sequences
Chapter 12. Using Multiple Tables
Chapter 13. Statistical Techniques
Chapter 14. Handling Duplicates
Chapter 15. Performing Transactions
Chapter 16. Introduction to MySQL on the Web
Chapter 17. Incorporating Query Resultsinto Web Pages
Chapter 18. Processing Web Input with MySQL
Chapter 19. Using MySQL-Based Web Session Management
Appendix A. Obtaining MySQL Software
Appendix B. JSP and Tomcat Primer
Appendix C. References
Colophone
Index
Index SYMBOL
Index A
Index B
Index C
Index D
Index E
Index F
Index G
Index H
Index I
Index J
Index K
Index L
Index M
Index N
Index O
Index P
Index Q
Index R
Index S
Index T
Index U
Index V
Index W
Index X
Index Y
Index Z


More Books
PHP Hacks
Processing Xml With Java - A Guide To Sax, Dom, Jdom, Jaxp, And Trax
The Koran (Holy Qur'an)
Macromedia Flash 8 Bible
Search Engine Optimization for Dummies
YouTube Traffic
PHP 5 for Dummies
Harry Potter and The Chamber of Secrets
Harry Potter and the Sorcerer's Stone
The Pilgrim's Progress
Wireless Hacks
Flash Hacks. 100 Industrial-Strength Tips & Tools
PayPal Hacks. 100 Industrial-Strength Tips and Tools
Amazon Hacks
Pdf Hacks
The Da Vinci Code
Google Hacks
The Holy Bible
Windows XP For Dummies
Harry Potter and the Half-Blood Prince
Seo Book
Upgrading and Repairing Networks
Macromedia Dreamweaver 8 UNLEASHED
Windows XP Annoyances
Windows XP Hacks
Microsoft Windows XP Power Toolkit
Teach Yourself MS Office In 24Hours
iPod & iTunes Missing Manual
PC Hacks 100 Industrial-Strength Tips and Tools
PC Overclocking, Optimization, and Tuning - 2th Edition
PC Hardware In A Nutshell 3rd Edition
PC Hardware in a Nutshell, 2nd Edition
Upgrading and Repairing PCs
Google for Dummies
MySQL Cookbook
Teach Yourself Macromedia Flash 8 In 24 Hours
PHP CookBook
Sams Teach Yourself JavaScript in 24 Hours
PHP5 Manual
Free Games Paper Airplanes