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]

Tab key, autocompletion using 
tab-delimited file format 
tab-delimited, linefeed-terminated format 
--table option 
table types
    evaluating tables for type 
tables
    adding indexes 
    aliasing of names 
    ALTER TABLE  [See ALTER TABLE statement]
    AUTO_INCREMENT columns, dropping to resequence 
    AUTO_INCREMENT columns, including 
    click to sort headings for query results 
    columns
        adding 
        dropping 
        moving 
    columns, displaying 
    combining rows from two tables  [See joins]
    conversion to transaction supporting types 
    copying to another server 
    creating 
    creating two tables from one 
        new indexes, adding 
    databases, listing all the tables in 
    deleting related rows in multiple tables 
        by replacing tables 
        cascaded deletes 
        mysql, using 
        programmatic deletion 
    design
        saving data storage space 
    dropping indexes 
    duplicates, eliminating 
    exporting as raw data 
    fully qualified table references 
    getting table structure information 
    HTML, structure in 
    information, database-independent methods of obtaining 
    joining a table to itself 
    joining from more than one database 
    matching rows from 2 or more 
    metadata, getting
        methodology, choosing 
    moving records between 
    with multiple sequences, creating 
    normalizing 
    redesigning 
    related table updates  [See related table updates]
    renaming 
    session records table creating 
    SQL format, exporting in 
    structure information, getting with result set metadata 
    table names, specifying in queries 
    table structure information
        uses for 
    temporary tables 
    TEMPORARY tables, creating 
    temporary tables, using for data transformation 
    testing for existence 
    types 
    types, determining server support for 
    unique names for, generating 
    using multiple 
    web scripting query results as 
        aliasing column names 
        borderless empty table cells fix 
        display, managing 
        visual appearance 
    XML, importing into MySQL 
tag libraries 
taglib directives  2nd 
<taglib> entries 
TCP/IP connections to local host 
tcsh, PATH environment variable, setting 
team standings, computing 
tee files 
    for reuse of queries 
--tee option 
temporal values 
    addition of zero for conversion to numbers 
    current time, determining 
    default values, enabling 
    interpreting strings as 
TEMPORARY tables  2nd 
temporary tables 
    using for data tranformation 
TERMINATED BY subclause 
terminator characters 
test harness programs 
test harness scripts, PHP 
Text::CSV_XS module, accessing documentation 
TIME column type 
    values, allowable ranges 
time intervals, decomposing 
    Python, using 
time of day, sorting by 
time values  [See also temporal values]
    addition of 
    combining with date values 
time zone discrepancies in time conversions 
time-formatting sequences 
time-related functions 
time_components( ) (Python) 
TIME_FORMAT( )  2nd  3rd 
    using for portions of times 
TIME_TO_SEC( )  2nd  3rd  4th 
times
    adding temporal intervals to 
    calculating intervals between 
    comparisons 
    conversion to seconds 
    decomposing 
        component-extraction functions, using 
        formatting functions, using 
        string functions, using 
    numbers, treating as 
    synthesizing 
        component-extraction functions, using 
        formatting functions, using 
    time zone adjustments 
    validity checking on subparts 
    validity checking on values 
TIMESTAMP columns  2nd  3rd 
    calculations on values 
    vs. DATETIME for recording record modification time 
    for permanent record creation time, using 
    format of values 
    potential impacts of moving 
    recording creation or modification time of records 
    records, recording modification time 
    values, reformatting for display 
TIMESTAMP values
    cgrouping in manageable categories 
timestamps, safeguarding table data with 
TINYINT, range of 
TLD files 
TLDs (Tag Library Descriptors) 
TO_DAYS( )  2nd  3rd  4th 
to_excel.pl 
to_null.pl 
Tomcat 
    built-in session management capabilities 
    dependencies 
    directory structure  2nd 
        applications 
        classes 
        configuration and control 
        operational directories 
    environment variables 
    installing 
    JDBC driver directory location 
    JDBC drivers and 
    JDBC drivers, installing 
    JSPs and 
    Manager application 
    mcb sample application, installation 
    restarting applications without restarting the server 
    servlet and JSP session interface 
    session management
        Java methods 
        MySQL, saving records in 
    session management with MySQL 
        server configuration files, changing 
        session expiration 
        session tables, creating 
        tracking 
    starting and stopping 
        Linux 
        Windows version 
    WAR (web archive) files 
    web scripts
        directory location 
    web scripts, running on 
    web site 
    WEB-INF directory 
    webapps directory 
    XML and 
Tomcat server 
track_vars configuration setting (PHP) 
track_vars directive (PHP) 
trailing spaces, preserving 
transactions 
    alternatives to, in nonsupporting environments 
    atomic operations as alternative to 
    BEGIN statement 
    canceling with ROLLBACK statement 
    Java programs, using in 
    MySQL, supporting versions 
    performing in programs 
    server concurrency 
    server integrity 
    SQL, performing with 
    table type availability, checking 
    tables, transactional types, specifying 
    transaction-safe table handlers, installing on server 
    verifying server support of 
        SHOW VARIABLES statement, checking with 
triple-equals operator (===)  2nd 
TRUNCATE( ) 
try blocks (Python) 
TYPE clauses 

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
500 Juegos Gratis 500 Giochi Gratis 500 Jeux Gratuits 500 Jogos Gratis 500 Kostenlose Spiele