index_V

 


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] [Y] [Z]

value restrictions (input data handling)
     ALLOW INVALID DATES SQL mode
     ERROR FOR DIVISION BY ZERO SQL mode
     INSERT IGNORE SQL mode
     NO ZERO DATE SQL mode
     NO ZERO IN DATE SQL mode
     overriding 2nd
     STRICT ALL TABLES SQL mode 2nd
     STRICT TRANS TABLES SQL mode 2nd
     TRADITIONAL SQL mode 2nd 3rd
     UPDATE IGNORE SQL mode
VALUES keyword
     INSERT statements 2nd
VARBINARY string data type 2nd 3rd
VARCHAR data types
     character sets
VARCHAR string data type 2nd 3rd 4th
variables
     in stored routines 2nd 3rd 4th
         SELECT INTO statements
         SET statements 2nd
variables (user)
     case sensitivity
     client connection specificity
     EXECUTE statements
     nonbinary string values
     NULL values
     SELECT statements
     SET statements 2nd
     syntax 2nd
viewing
     character sets 2nd
     global variables
     index metadta 2nd 3rd 4th 5th
     index names
     InnoDB storage engine status information 2nd
    metadata
         in databases 2nd 3rd
    privileges
         in user accounts 2nd
     server status variables 2nd 3rd
     server system variables 2nd 3rd
     session variables
    storage engine availability
         in servers 2nd
     table metadta 2nd 3rd 4th 5th
views
     algorithms 2nd
         specifying
     ALTER VIEW statements
     base table namespaces
     benefits of 2nd
     CHECK TABLE statements
    columns
         aliases 2nd
         names 2nd
    CREATE VIEW statements
         privilege requirements
    creating
         via MySQL Query Browser
    defining
         CREATE VIEW statements 2nd 3rd
     DROP VIEW statements 2nd
         privilege requirements
     metadata, obtaining 2nd
    OR REPLACE clauses
         privilege requirements
     replacing
     required privileges 2nd
     restrictions 2nd
     SHOW CREATE VIEW statements
         privilege requirements
     SHOW FULL TABLES statements 2nd
     updates 2nd 3rd 4th 5th
VIEWS table (INFORMATION SCHEMA database) 2nd
virtual databases
    INFORMATION SCHEMA
         access syntax 2nd 3rd
         limitations of
         versus SHOW statements 2nd
virtual tables [See views]

 


MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net