MySQL, Second Edition

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]

C language

C# language

C++ language

calculating dates

calculations 2nd 3rd

CALL command

cancel (\c) command

capitalize function

carriage return (\r)

Cartesian product

CASE conditional

casting

CEILING() function 2nd

CGI scripts 2nd

CHANGE COLUMN clause 2nd 3rd

CHAR data type 2nd 3rd

character sets 2nd 3rd 4th 5th

characters [See also strings.]

     escaping 2nd 3rd

     non-English 2nd 3rd

     problematic 2nd 3rd 4th 5th

     special 2nd 3rd

    wildcard [See wildcard characters.]

CHECK TABLE query

checksum, verifying

chmod command 2nd

classes

     character 2nd

     Java 2nd

     mysqli extension

CLASSPATH directories

classpaths 2nd 3rd

clauses

     ADD COLUMN 2nd

     ADD INDEX 2nd

     ALTER TABLE 2nd

     BETWEEN

     CHANGE COLUMN 2nd 3rd

     DROP COLUMN 2nd

     DROP INDEX 2nd

     ELSEIF

     GROUP BY

     LAST_INSERT_ID

     LIMIT 2nd

     ORDER BY 2nd 3rd 4th

     RENAME AS 2nd

     SQL

     try 2nd 3rd 4th

     WHERE 2nd 3rd

client ID 2nd 3rd

client programs 2nd 3rd

close() method

Codd, E.F 2nd

collations 2nd 3rd

columns

     adding 2nd

     calculations on

     changing data types 2nd 3rd

     concatenating

     customizing

    data types [See data types.]

     date

     default values 2nd 3rd

     displaying

     duplicate values

     extra

     functions and

     indexes 2nd

     keys

     length of 2nd 3rd

     multiple

     names 2nd 3rd 4th

     NULL values 2nd 3rd 4th 5th 6th

     number of

     numeric 2nd

     order of 2nd

     performance and

     redefining

     referring to

     removing from tables 2nd

     retrieving

     selection

     separators

     size

     text sorts

     triggers and 2nd

     values 2nd 3rd 4th 5th

     VARCHAR 2nd

commands [See also specific commands.]

     in Terminal window

     Java

     over multiple lines

     running in Windows 2nd

comments 2nd 3rd 4th 5th

COMMIT command 2nd

comparators, SQL

CONCAT() function 2nd

CONCAT_WS() function

concatenation 2nd

conditional joins

conditionals 2nd 3rd 4th

configuration

     basic options for

     changing

     MySQL on Windows

     problems with

configuration files 2nd [See also option files.]

connections

     $database_connection variable

     closing 2nd 3rd

     database (Java)

     database (Perl) 2nd

     database (PHP)

     disconnect() function

     errors

     Java Database Connectivity

     mysqli_connect()

     server 2nd

console option 2nd

console window 2nd

constants 2nd

constructs 2nd 3rd 4th 5th

control flow functions

control structures

CONVERT() function 2nd

CONVERT_TZ() function

COUNT() function 2nd 3rd

CPAN modules 2nd 3rd

CREATE DATABASE command 2nd

CREATE FUNCTION command

CREATE keyword

CREATE privilege 2nd

CREATE PROCEDURE command 2nd

CREATE ROUTINE privilege 2nd 3rd

CREATE TABLE command

CREATE TEMPORARY TABLES privilege 2nd

CREATE TRIGGER command 2nd

CREATE USER command

CREATE USER privilege 2nd

CREATE VIEW command 2nd

CREATE VIEW privilege 2nd 3rd

createStatement() method 2nd 3rd 4th

CURDATE() function 2nd 3rd 4th

cursors

CURTIME() function 2nd 3rd