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 |