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]

absolute pathnames 
Òaccess deniedÓ message 
ad counters, using sequences for 
ADD clause 
    FIRST and AFTER specifiers 
add_element.py 
AFTER 
ages, calculating in years 
    in months 
aggregate functions 
    correlation coefficients, calculating 
    GROUP BY, used with 
    linear regressions, calculating 
    NULL values and 
    per-group descriptive statistics, calculation using 
    statistical data, calculation using 
    WHERE clauses and 
aliases 
    for columns in sorting operations 
    for expressions
        used as sorting criteria 
    for expressions{aliases
        expressions] 
    for self-joins 
    for tables 
ALL keyword 
ALTER IGNORE TABLE statement 
ALTER TABLE statement  2nd 
    columns
        adding 
        AUTO_INCREMENT type, adding 
        AUTO_INCREMENT type, resequencing 
        default values, changing 
        dropping 
        moving 
        renaming 
        type, reassigning 
    default value attributes and 
    indexes 
        adding 
        dropping 
    NULL value attributes and 
    sequence counter, resetting 
    sequence range, extension using 
    sequencing behavior, changing with 
    using table normalization 
    tables
        transaction supporting types. converting to 
    tables, renaming 
    TYPE clauses 
alternations  2nd 
AND operator in FULLTEXT searches 
anniversary dates, calculating 
Apache 
    API extension modules for 
    CustomLog directive 
    directory structure 
    error log 
    logging to MySQL 
        logfiles, analyzing 
        set up 
    PHP, configuring for 
    references 
    suEXEC mechanism 
    web scripts
        Perl-based 
        PHP-based 
        Python-based 
    web scripts, directory location for 
    web scripts, running on 
Apache Software Group, web sites 
Apache::Session module  2nd 
    obtaining 
APIs (application programming interfaces) 
    Apache, extension modules for 
    C API 
    communications protocols and 
    connection, database selection, disconnection 
        Java, using 
        Perl, using 
        PHP, using 
        Python, using 
    database server independence, designing for 
    datafile columns, extraction and rearranging of 
    datafile formats, converting 
    dependencies 
    duplicates, detecting programmatically 
    encoding special characters using 
        Java 
        Perl 
        PHP 
        Python 
    event counts, retrieval using 
    export programs, writing 
    HTML-encoding methods 
    input extraction conventions 
    MySQL drivers and 
    MySQL, used with 
        Versions 
    NOT IN( ) subselects, simulating in programs 
    pattern matching and SQL pattern characters 
    programmatic multiple table deletes 
    related table updates, performing programmatically 
    reports, generating 
    rollbacks and exception handling 
    sequence values, accessing with 
    session management 
    SHOW COLUMNS, using to get table structure information 
    software, obtaining 
    sort operations, using for 
    statement terminators, absence of 
    subselect queries, simulating in programs 
    summary calculations using 
    table information, methods of getting 
    transactions
        abstractions, mapping onto SQL 
        program control structures 
        in programs 
        support 
    unattached records, deleting programmatically 
    URL-encoding methods 
    web script generation using 
    web scripts, pathname acquisition 
application programming interfaces  [See APIs]
application/octet-stream content type, forcing download with 
applications, customizing for MySQL versions 
arithmetic operators, JSTL 
AS clause  2nd 
ASC sort order 
ASCII charts 
atomic operations as alternative to transactions 
auto-commit mode, suspending 
auto-completion 
    database and table names 
AUTO_INCREMENT columns 
    adding to existing tables 
    creating multiple sequences using 
    duplicate values, impact on 
    extending sequence range 
    generating multiple sequences using 
    hit logs, using in 
    integer types requirement 
    item tracking using 
    multi-column indexes, setting up 
    multiple sequence tables, managing 
    NULL values and 
    record deletions, impact on 
    reinitializing the sequence 
    resequencing, advisability 
    sequence columns, setting up 
    sequence values, generating in 
    sequencing behavior, changing 
    starting value, setting 
    table types and 
    UNSIGNED typing 
    using values to relate tables 
AUTOEXEC.BAT, PATH environment variable, setting 
AVG( ) 
    strings, inapplicability to 

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