D | 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