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]
data
exporting and importing
[See data transfers]
data source name
[See DSN]
data transfers
2nd
[See also datafiles]
between MySQL and Microsoft Access
data content issues
databases, copying between servers
date values, converting year format from two-digit to four-digit
dates, exportation in new format, Perl script for
exporting files with NULL values from MySQL
FileMaker Pro and MySQL, between
format conversion issues
importing files with NULLs into MySQL
LOAD DATA
[See LOAD DATA statement]
Microsoft Excel and MySQL, between
mysql, redirection of output
mysqlimport
NULLs
query results, exporting from MySQL
recurring problems
shell command invocation
tables, copying between servers
tables, exporting to files
temporary tables, via
validation
XML, exporting query results as
data types, case sensitivity
database name qualifiers
DATABASE( )
database-independent architecture
databases
copying to another server
current database, determining
design guidelines
listing all on a server
multi-database table joins
selecting
SQL format, exporting in
storing images on, pros and cons
tables, listing all
testing for existence of
datafiles
columns, extracting and rearranging
formats
converting
hex dump programs, checking with
line-ending sequences
loading
[See LOAD DATA statement]
NULLs, checking representation of
NULLs, representing in
structural information
tab-delimited file format, linefeed-terminated
table structure, determining from
validating
DATE column type
date formats and pattern matching
date-and-time values
conversion to seconds
generation from a date and time
date-related functions
DATE_ADD( )
2nd
3rd
DATE_FORMAT( )
2nd
3rd
4th
5th
6th
TIMESTAMP values, for reformatting
using for portions of dates
DATE_SUB( )
2nd
3rd
dates
adding time to
anniversary dates, calculating
calculated, for setting record lifetimes
calculating intervals between
Perl, using
calculating one from another using substring replacement
comparison
conversion to days
date conversion utilities, writing
date values, combining with time values
decomposing
component-extraction functions, using
formatting functions, using
string functions, using
determining for current week days
finding for weekdays of other weeks
Perl, using
finding the day of the week for
first and last days of month, determining
intervals vs. spans
intervals, calculating in years
in months
ISO 8601 standard
ISO dates, generating from non-ISO dates
leap years, detection of
numbers, treating as
retrieving in non-ISO format
shifting by a given amount
sorting by
SQL statement, conversion using
synthesizing
component-extraction functions, using
formatting functions, using
temporary tables, format conversion using
time zone adjustments
validity checking on subparts
with missing components, conversion to ISO format
written month to numeric month format, conversion from
year format, conversion from two-digit to four-digit
DATETIME column type
2nd
vs. TIMESTAMP for recording record modification time
DATETIME values, grouping in managable categories
DAYNAME( )
2nd
3rd
4th
DAYOFMONTH( )
2nd
3rd
DAYOFWEEK( )
2nd
3rd
4th
DAYOFYEAR( )
2nd
Òon this dayÓ problems, and
sorting issues
days, conversion to dates
days_in_month( )
DBD::mysql module
DBI module (Perl)
2nd
error checking, attributes for
DBI:mysql:options module
DBTools
datafiles, determining table structure using
importation, Microsoft Accesss tables to MySQL
web site
default values
ALTER TABLE and
columns
defined( ) (Perl)
definition lists, web scripting query results as
[See also lists]2nd
DELETE É LIMIT
bug affecting some MySQL versions
for removal of duplicate records from tables
DELETE statement
multiple-table syntax
rows, finding the number affected
unattached records, deleting
delete_dups( )
deleting related rows in multiple tables
by replacing tables
cascaded deletes
mysql, using
programmatic deletion
DESC sort order
2nd
DictCursor cursor type (Python)
disconnect( ) (PHP MySQL_Access class)
display_image.pl
displayResultSet( ) (Java)
2nd
DISTINCT
2nd
and expressions
do( ) (Perl)
placeholders, binding values to
rows affected by a query, counting
doGet( ) (Java)
doPost( ) (Java)
DOS command-line environment, limitations of
double quotes (")
download.php
DriverManager.getConnection( ) (Java)
DROP clause
DROP DATABASE statement, immunity to ROLLBACK
DROP INDEX statement
DSN (data source name)
MySQL, format for
duplicate records
case sensitivity and
identifying
joining a summary to the original table
identifying and counting
identifying specific records
methods of handling
preventing
at record-creation time
AUTO_INCREMENT columns for PRIMARY KEYs
bulk-load operations, during
INSERT IGNORE statement
REPLACE statement
queries that result in none
queries, detecting with
self-joins, eliminating from
specific instances, removal using LIMIT
tables, eliminating from
by adding an index
table replacement, using
|
Main Menu
|
