MySQL Cookbook

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]

%c format sequence

C programming language

C shell

<c:choose> JSTL tag

<c:forEach> JSTL tag

<c:if> JSTL tag

<c:out> JSTL tag 2nd

     paragraph text, encoding query results with

<c:param> JSTL tag

<c:set> JSTL tag

<c:url> JSTL tag

calculator, using mysql as

caret (^), matching patterns 2nd

     Perl

carriage return (\r)

Cartesian products

case-sensitivity

     collations

     duplicate identification and

     i flag for Perl pattern constructors

     MIN( ) and MAX( ) function, controlling

     pattern matching and

     Perl DBI

     string comparisons and

     string sorts, controlling

CAST( ) function

cat program

     -n option, numbering output

CATALINA_HOME environment variable

CCYY-MM-DD format 2nd 3rd

     importing non-ISO date values

     pattern matching and

cgi module

     Python

     Ruby 2nd

         escapeHTML method, producing paragraph tags

         forms, generating

cgi-bin directory

     Python web scripts and

     Ruby scripts and

cgi.escape( ) methods (Python)

CGI.escape⁠(⁠ ⁠ ⁠)

     Ruby method

CGI.escapeHTML⁠(⁠ ⁠ ⁠)

     PageTemplate

     Ruby method

CGI.pm module (Perl) 2nd 3rd

     checkboxes, creating

     input parameters

    query results

         hyperlinks

         tables (HTML)

         unordered lists, generating

    query results, displaying

         paragraph text

     special characters, encoding

CGI::Session class (Ruby) 2nd

CHAR data type 2nd

CHAR_LENGTH( ) function (SQL)

character numeric values

CHARACTER SET attribute

     data types and

character sets

     changing

     clients, setting

     nonbinary strings

--character-set-server option

CHARSET( ) function

checkbox_group( ) function (Perl)

checkboxes (HTML)

chmod program 2nd

     library file access privileges

     scripting languages, executing scripts

     shell scripts, executing

class statement (Java) 2nd

Class.forName( ) method

className attribute (JDBC Manager element)

CLASSPATH environment variable (Java) 2nd 3rd 4th

"click to sort" table headings

client API architecture

client program

client time zones, setting

client-side validation

cloning tables

cmd.exe 2nd

COLLATE attribute 2nd 3rd 4th

     data types and

collation sorts

COLLATION( ) function

--collation-server option

collations

     changing

     checking

colon (:)

     PERL5LIB library files, installing

column aliases 2nd

column delimiters, replacing tabs with

column heading, suppressing

columns

     aliases for

     case-insensitive/case-sensitive

     combining to construct composite values

     definitions, accessing

     ENUM/SET columns definitions, adding

     extending ranges of sequences

     extracting/rearranging data

     giving better names to query results

     ignoring datafiles

     joining tables and

     order, specifying input

     output names in programs, referring to

     resequencing

     selecting

     sequence

         data types, choosing for

     specifying which to select

     substrings, sorting using

     web page elements, mapping definitions into

--columns option

com.mysql.jdbc.Driver

comma-separated values (CSV) 2nd 3rd

     importing

command line

     executing programs from

     getting parameters from

     option file parameters and

     starting and stopping mysql

commit method (Ruby)

COMMIT statement

commit( ) method

     Java

     Perl

     PHP

     Python

common Tomcat directory

comparison expressions

comparison operators

     case-sensitivity, controlling

compound-statement object

COMPRESS( ) function

CONCAT( ) function 2nd 3rd 4th 5th

concurrency issues

conditional testing in templates

conf directory

connect( ) method

     Java

     Perl 2nd 3rd

         modules and

     PHP 2nd 3rd

     Python

     Ruby

connection parameters 2nd

connectionURL attribute (JDBL Store element)

content of datafiles, manipulating

Content-Length: header

Content-Type: header 2nd

     downloads, serving

<Context> element

CONTINUE handler

CONVERT( ) function

CONVERT_TZ( ) function

cookies

correlation coefficients

COUNT( ) function 2nd 3rd

     duplicates, counting and identifying

     duplicates, eliminating with DISTINCT

     HAVING clause and

     IFNULL( ) function and

     repetitive values and

     running averages and

     subgroups, dividing into

     summarizing with

     unique values, determining with

counters (sequence generators)

counting summaries

CPAN 2nd 3rd

     Excel, modules for

CREATE DATABASE statement

CREATE ROUTINE privilege

CREATE TABLE statement 2nd

     cloning tables with

     exporting tables as SQL statements

     saving query results in tables with

     table structure and

     table structure, guessing

CREATE TEMPORARY TABLE statement

     generating unique table names and

createStatement( ) method (Java)

cron jobs 2nd

csh shell

     library files, installing

CSV (comma-separated values) 2nd 3rd

     importing

Ctrl-A, editing statements

Ctrl-D, editing statements

Ctrl-D, terminating sessions

Ctrl-E, editing statements

Ctrl-U, canceling statements (Unix/Linux)

cumulative sums, finding

cumulative values in rows 2nd

CURDATE( ) function

curly brackets ({ })

     markup indicators in Smarty templates

     matching patterns

CURRENT_USER( ) function

CURTIME( ) function 2nd

Cygwin (Cygnus tool for Windows)