Index P

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

p()
    CGI.pm Perl module 
PACK KEYS option
    creating tables 
pack_isam utility  2nd  3rd  4th 
    options
        list of  2nd  3rd  4th 
        standard options supported 
packing data
    in BLOB columns  2nd 
pager command 
param()
    invoking CGI scripts with parameters 
    Web input parameters 
parameter binding
    Perl DBI API  2nd 
parameters
    C API functions  2nd 
    connection parameters.  [See connection parameters]
    input parameters
        PHP API  2nd  3rd  4th  5th  6th 
    invoking scripts with
        CGI.pm Perl module  2nd  3rd  4th  5th  6th 
    PHP API functions  2nd 
parameters.  [See variables]2nd  [See also options]
parentheses ()
    grouping operators 
partitions
    raw partitions
        in InnoDB tablespace  2nd 
Password column (grant tables) 
password command 
PASSWORD option
    creating tables 
    setting variables 
PASSWORD() function 
passwords
    changing  2nd 
    encryption 
    for login authentication.  [See login authentication]
    for server connections  2nd 
    load_default() function 
    log file security 
    on command line 
    prompts for 
    root password
        resetting  2nd 
    setting
        for additional servers  2nd 
        for anonymous accounts 
        for root account  2nd  3rd 
pathnames
    for InnoDB tablespace
        specifying on Windows 
pattern matching
    PHP API 
    query optimization  2nd 
    Web-based applications searching example  2nd  3rd  4th 
    when retrieving records  2nd  3rd 
pattern-matching operators  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    type conversion 
PEAR (PHP Extension and Add-on Repository) 
percent sign (%)
    modulo operator 
    wild card character 
    wildcard character  2nd  3rd 
performance
    data directory structure, effect of  2nd  3rd 
    PHP 3 versus PHP 4 
    placeholders
        Perl DBI API 
    selecting column types 
        fixed-length versus variable-length types  2nd  3rd 
        indexable types 
        NULL versus NOT NULL types 
        numeric versus string types  2nd 
        smaller versus larger types  2nd 
    selection criteria for APIs  2nd  3rd  4th  5th  6th  7th  8th 
performance tuning  2nd 
    server variables
        InnoDB-related variables, list of  2nd 
        list of  2nd  3rd 
        setting  2nd  3rd 
performance.  [See query optimization]
PERIOD_ADD() function 
PERIOD_DIFF() function 
Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    attributes  2nd 
        database handle attributes  2nd  3rd  4th  5th 
        dynamic attributes  2nd 
        general handle attributes  2nd  3rd 
        statement handle attributes  2nd  3rd  4th  5th  6th  7th  8th 
    comments 
    connection parameters  2nd  3rd  4th  5th  6th 
    data validation  2nd 
    database connections  2nd 
    debugging 
        with print statements  2nd  3rd 
        with tracing  2nd  3rd  4th 
    declaring variables  2nd 
    directory listing example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    environment variables 
    error handling  2nd  3rd  4th  5th  6th 
    escaping quotation marks  2nd  3rd  4th  5th 
    external support 
    handles  2nd 
    HTML document example  2nd  3rd  4th  5th 
    member common interests example  2nd 
    member entry editing example  2nd  3rd  4th  5th  6th  7th 
    membership renewal example  2nd  3rd  4th  5th  6th  7th  8th 
    memory management 
    memory usage versus PHP 
    methods  2nd  3rd  4th 
        administrative methods  2nd  3rd 
        class methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        database handle methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        fetching rows 
        general handle methods  2nd 
        statement handle methods  2nd  3rd  4th  5th  6th  7th 
        utility functions  2nd 
    objects 
    operational overview  2nd  3rd  4th  5th  6th  7th  8th  9th 
    parameter binding  2nd 
    placeholders  2nd  3rd  4th  5th  6th 
    portability  2nd 
    predecessor of 
    query execution  2nd 
    query preparations  2nd 
    query result processing
        testing for NULL values  2nd 
        with result set  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
        without result set  2nd 
    references 
    requirements 
    result set metadata  2nd  3rd  4th  5th  6th 
    result sets
        counting rows fetched 
        fetching complete result sets  2nd  3rd  4th  5th 
        fetching rows  2nd  3rd  4th  5th  6th  7th  8th  9th 
        fetching single rows  2nd  3rd 
    running scripts  2nd 
    strengths of 
    text manipulation 
    transactions  2nd  3rd  4th 
    variables 
    Web-based applications  2nd  3rd 
        Apache Web server setup  2nd  3rd 
        CGI.pm Perl module  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th 
        database browser example  2nd  3rd  4th  5th  6th 
        MySQL server security  2nd  3rd  4th  5th 
        score browser example  2nd  3rd  4th  5th 
        searching example  2nd  3rd  4th  5th  6th  7th 
Perl modules
    installation on UNIX  2nd  3rd 
    installation on Windows  2nd 
    obtaining for installation  2nd  3rd 
perldoc command 
permissions
    for data directory 
persistent connections
    PHP API 
    versus non-persistent connections 
PHP
    installation on UNIX  2nd  3rd 
    installation on Windows 
    obtaining for installation  2nd  3rd 
PHP 3
    performance versus PHP 4 
PHP 4
    performance versus PHP 3 
PHP API  2nd  3rd  4th  5th  6th  7th  8th 
    comments in 
    data retrieval example  2nd  3rd  4th 
    database selections 
    dynamic output  2nd 
    error handling  2nd  3rd  4th  5th  6th  7th  8th  9th 
        query failures  2nd  3rd 
    escaping quotation marks  2nd  3rd 
    external support 
    file extensions 
    functions
        connection management  2nd  3rd  4th  5th  6th 
        deprecated  2nd 
        error handling  2nd  3rd 
        information gathering  2nd  3rd 
        parameters  2nd 
        queries  2nd  3rd  4th  5th  6th  7th  8th  9th 
        result set processing  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st 
        row fetching 
    global variables 
    hidden fields  2nd  3rd  4th 
    include files  2nd  3rd  4th  5th  6th  7th  8th 
    include statement
        versus require statement 
    input parameters  2nd  3rd  4th  5th  6th 
    integer testing 
    login authentication  2nd  3rd  4th  5th  6th  7th 
    member entry editing example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    memory management 
    memory usage versus Perl 
    opening and closing tags  2nd  3rd  4th 
    operational overview  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    operators
        === 
    pattern matching 
    portability  2nd 
    predecessor of 
    president quiz example  2nd  3rd  4th  5th  6th 
    query result processing  2nd  3rd  4th 
        testing for NULL values  2nd 
        with result set  2nd  3rd  4th  5th  6th 
        without result set  2nd 
    register globals configuration setting 
    server connections  2nd  3rd  4th  5th 
    server queries  2nd 
    standalone scripts  2nd 
    strengths of 
    student scores example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
    switch statement 
    syntax similarities with other languages 
    text manipulation 
    transactions 
    variables  2nd 
PHP Extension and Add-on Repository (PEAR) 
PHP/FI 
phrase searches 
PI() function 
picking.  [See selecting]
PID (process ID) file
    in data directory 
pid_file variable 
ping command 
ping()
    Perl DBI database handle method 
pipe (|)
    bitwise OR operator 
placeholders
    Perl DBI API  2nd  3rd  4th  5th  6th 
plus sign (+)
    addition operator  2nd 
pointer variables.  [See also handles]
pointers.  [See also references]
port variable 
portability
    of tables  2nd 
    selection criteria for APIs  2nd 
POSITION() function 
POSIX character classes
    regular expressions 
pound sign (#)
    Perl DBI comments 
POW() function 
POWER() function 
precedence of operators  2nd  3rd  4th 
PRECISION attribute
    Perl DBI API 
prefix lengths
    indexes 
prefixes
    indexes  2nd 
preg_match()
    PHP pattern matching 
prepare()
    Perl DBI database handle method 
    Perl DBI queries  2nd 
prepare_cached()
    Perl DBI database handle method 
president quiz example
    PHP API  2nd  3rd  4th  5th  6th 
president table (U.S. Historical League example) 
    creating  2nd  3rd 
preventive maintenance
    administration duties 
preventive maintenance schedules  2nd  3rd 
price
    selecting ISPs  2nd  3rd 
PRIMARY KEY clause 
PRIMARY KEY indexes  2nd 
PRIMARY KEY keyword
    creating tables 
PRIMARY keyword
    retrieving rows from tables 
print command 
print statements
    debugging Perl DBI API with  2nd  3rd 
print_error()  2nd 
PrintError attribute
    Perl DBI API 
    Perl DBI error handling  2nd  3rd  4th  5th  6th 
printf()
    printing binary data 
printing
    binary data 
priorities.  [See scheduling queries]
privacy
    of user-specific option files 
privacy issues
    selecting ISPs  2nd 
privacy.  [See security]
privilege columns (grant tables)  2nd  3rd  4th  5th 
privileges
    administrative privileges (grant tables)
        list of  2nd  3rd 
    avoiding risks  2nd  3rd 
    database and table privileges (grant tables)
        list of  2nd 
    displaying  2nd 
    displaying available 
    flushing  2nd  3rd 
    granting  2nd  3rd  4th  5th  6th  7th 
        allowing privilege administration  2nd 
        hostname and username, specifying  2nd 
        limiting resource consumption  2nd 
        SSL connections, specifying  2nd 
    of anonymous accounts 
    record-level privileges
        lack of support for 
    revoking  2nd  3rd  4th 
    troubleshooting
        example of  2nd  3rd  4th 
    types of  2nd  3rd  4th 
PRIVILEGES option
    flushing caches 
privileges.  [See also grant tables]
PROCEDURE ANALYSE() clause
    retrieving rows from tables 
PROCEDURE clause
    retrieving rows from tables 
PROCEDURE_ANALYSE()
    query optimization  2nd 
PROCEDURE_ANALYSE() function 
process ID (PID) file
    in data directory 
PROCESS privilege  2nd  3rd  4th 
    avoiding risks 
process threads.  [See threads]
process_query()
    alternatives to  2nd 
processlist command 
programming MySQL
    APIs for  2nd  3rd 
        C API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th  48th  49th  50th  51st  52nd  53rd  54th  55th  56th  57th  58th  59th  60th  61st  62nd  63rd  64th  65th  66th  67th  68th  69th  70th  71st  72nd  73rd  74th  75th  76th  77th  78th  79th  80th  81st  82nd  83rd  84th  85th  86th  87th  88th  89th  90th  91st  92nd  93rd  94th  95th  96th  97th  98th  99th  100th  101st  102nd  103rd  104th  105th  106th  107th  108th  109th  110th  111th  112th  113th  114th  115th  116th  117th  118th  119th  120th  121st  122nd  123rd  124th  125th  126th  127th  128th  129th  130th  131st  132nd  133rd  134th  135th  136th  137th  138th  139th  140th  141st  142nd  143rd  144th  145th  146th  147th  148th  149th  150th  151st  152nd  153rd  154th  155th  156th  157th  158th  159th  160th  161st  162nd  163rd  164th 
        Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th  48th  49th  50th  51st  52nd  53rd  54th  55th  56th  57th  58th  59th  60th  61st  62nd  63rd  64th  65th  66th  67th  68th  69th  70th  71st  72nd  73rd  74th  75th  76th  77th  78th  79th  80th  81st  82nd  83rd  84th  85th  86th  87th  88th  89th  90th  91st  92nd  93rd  94th  95th  96th  97th  98th  99th  100th  101st  102nd  103rd  104th  105th  106th  107th  108th  109th  110th  111th  112th  113th  114th  115th  116th  117th  118th  119th  120th  121st  122nd  123rd  124th  125th  126th  127th  128th  129th  130th  131st  132nd  133rd  134th  135th  136th  137th  138th  139th  140th  141st  142nd  143rd  144th  145th  146th  147th  148th  149th  150th  151st  152nd  153rd  154th  155th  156th  157th 
    APIS for
        Perl DBI API 
    APIs for
        Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th  48th  49th  50th  51st  52nd  53rd  54th  55th  56th  57th  58th  59th  60th  61st  62nd 
        PHP API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th  48th  49th  50th  51st  52nd  53rd  54th  55th  56th  57th  58th  59th  60th  61st  62nd  63rd  64th  65th  66th  67th  68th  69th  70th  71st  72nd  73rd  74th  75th  76th  77th  78th  79th  80th  81st  82nd  83rd  84th  85th  86th 
    APIs FOR
        PHP API 
    APIs for
        PHP API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th  48th  49th  50th  51st  52nd  53rd  54th  55th  56th 
        selection criteria  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th 
    reasons for  2nd  3rd  4th  5th  6th  7th  8th 
programs
    list of  2nd 
    options  2nd 
        boolean option syntax  2nd 
        environment variables  2nd 
        option files  2nd  3rd  4th  5th  6th  7th 
        SSL options, list of  2nd 
        standard options, list of  2nd  3rd 
    variables
        setting  2nd 
programs.  [See also names of specific programs]
prompt
    for mysql command
        changing  2nd 
PROMPT command  2nd 
prompt command 
prompts
    for mysql program  2nd 
    mysql program
        escape sequences, list of  2nd 
pronunciation of MySQL 
pronunciation of SQL 
protocol_version variable 
ps command (UNIX)
    data directory location 
PURGE MASTER LOGS statement  2nd  3rd 
PURGE MASTER statement 
putc()
    printing binary data 



MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

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