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]

\d (digit) Perl pattern element

%d (integers) format specifier

\D (nondigit) Perl pattern element

%d format sequence

dash (-), matching dates and

data source name (DSN)

data types

     choosing

     sequence columns, choosing for

     temporal, choosing

data values, handling special characters and NULL values

data, importing and exporting

     bad input, obtaining diagnostics

     converting to different formats

     copying tables/databases to different servers

     date-processing utilities, writing

     dates with missing components

     dates/times, matching

     different operating systems and

     email addresses, using patterns to match

     Excel, exchanging data between

     export programs, writing

     exporting dates using non-ISO formats

     extracting and rearranging file columns

     guessing table structure from datafiles

     ignoring datafile columns

     importing XML

     input column order, specifying

     LOAD DATA statement and mysqlimport

     location, specifying

     lookup tables, using to validate

     matching broad content types

     Microsoft Access, exchanging data between

     non-ISO date value

     NULL values, importing/exporting

     numeric values, matching using patterns

     preprocessing input values before inserting them

     query results, exporting

     quotes/special characters, dealing with

     skipping datafile lines

     SQL mode, controlling bad input data

     structure of

     table metadata, using to validate data

    tables, exporting

         SQL format

         text files

     two-digit year values to four-digit form, converting

     validating data with pattern matching

     validating/transforming

     validity checking on date/time subparts

     XML, exporting

Data::Validate module (Perl)

database drivers

database handle methods

DATABASE( ) function 2nd

     determining default databases

database_manager (Ruby CGI object)

databases

     auto-completion and

     checking existence of

     connecting, selecting and disconnecting

     copying to different servers

     creating

     exporting

     join between tables of different

     web input, storing

datafiles 2nd

     converting to different formats

     different operating systems, reading from

     lines, skipping

     location of, specifying

     structure of

     Windows, naming under

dataSource attribute (JSTL)

DATE data type

     changing MySQL's ISO format and

     date-based sorting

DATE type

DATE( ) function

date-based sorting

date-based summaries

DATE_FORMAT( ) function 2nd 3rd 4th

     extracting parts of dates/times

     synthesizing dates/times

DATEDIFF( ) function

dates

     calculating intervals between

     calendar days, sorting by

     changing MySQL's date format

     date-processing utilities, writing

     day of week, sorting by

     determining current

     exporting non-ISO formats

     extracting

     matching using patterns

     missing components, using

     sorting

     synthesizing from component values

     two-digit year values to four-digit form, converting

     validity checking

DATETIME data type 2nd

     date-based sorting

     time of day, sorting

DAYNAME( ) function 2nd 3rd

DAYOFMONTH( ) function

DAYOFWEEK( ) function 2nd 3rd

DAYOFYEAR( ) function 2nd

DB-API (Python)

     placeholders and

     transactions and

db.hold_conn parameter

db.host parameter

db.name parameter

db.pass parameter

DB.php files

db.table parameter

db.user parameter

DB_FETCHMODE_ASSOC argument (fetchRow( ) method)

DB_FETCHMODE_OBJECT argument (fetchRow( ) method)

DB_FETCHMODE_ORDERED argument (fetchRow( ) method)

DB_result object (PHP)

DBD::mysql

DBI interfaces

    Java

         error checking

         statements, sending and retrieving

     Perl

         error checking

         statements, sending statements

         transactions, using

     PHP

         error checking

     programing languages and

     Python 2nd

         error checking

     Ruby 2nd

         error checking

         sending and retrieving results

DBI module (Perl)

     connecting to databases

     statements, sending

DBI::DatabaseError object

DBI::Row objects

dd( ) function (Perl)

DD-MM-YY format

debug <Context> attribute

debug attribute (JDBC Manager element)

debugging [See errors, checking for]

default argument (JSP)

DEFAULT attribute

default character set

DEFAULT clause

default databases, determining

default output styles

--default-character-set option

--default-time-zone option

defined( ) function (Perl)

definition lists (HTML)

DELETE statement 2nd 3rd

     eliminating duplicates from tables

     mismatched or unattached row, identifying and removing

DELETE trigger

delimiter command

delimiters, replacing tabs with

DESC clause

DESCRIBE statement

descriptive statistics

     per-group

DETERMINISTIC characteristic

DictCursor cursor type (Python)

die( ) function (Perl)

DIR statement

     file extensions, viewing

disordering result sets

display order, controlling

displayResultSet( ) method (Java)

DISTINCT clause 2nd

     duplicates, eliminating with

     repetitive values and

DISTINCTROW clause

<dl> definition list HTML tag

dl method (Ruby)

do method (Ruby)

do( ) method (Perl) 2nd

     placeholders and

     sending statements

docBase <Context> attribute

doGet( ) method (Java)

dollar sign ($), matching patterns 2nd

     Perl

domain names in Java code

domain order, sorting hostnames in

doPost( ) method (Java)

dot (.), matching patterns

     Perl

dotted-quad IP values, sorting

down arrow key, editing statements

DriverManager.getConnection( ) method (Java)

driverName attribute (JDBL Store element)

DROP DATABASE statement

DROP TABLE statement, creating temporary tables and

DSN (data source name)

<dt> definition term HTML tag

dt( ) function (Perl)

duplicates

     counting/identifying

     self-join results and

     tables, preventing