D
data
adding to database, 7890
comparing, 128, 142143, 145147
controlling amount of, 121123
creating tables with, 8190
customizing for specific needs, 120125
deleting, 108117
e-commerce and, 2
evaluating, 143145
exporting, 271273
grouping, 176183
importing. See importing
inserting from text file, 8081
inserting into tables, 6776
integrity of, 60
joining, 183190
modifying in databases, 95107
ordering, 176177, 181183
refining selection of, 126129
removing duplicates, 123124
replacing, 9597
shaping with SELECT command, 123125
sort order, 135138
updating, 9799
Data Source Name . See DSN
data types, 4052
choosing, 40
date, 4751
importance of, 40
in MySQL, 4041
number, 4145
size , 42
time, 4751
database functions, 265270
database-level privileges, 282
databases
adding data to, 7890
backing up. See backups
basics of, 23
connecting to. See connections
creating, 62, 6466
data in. See data
e-commerce and, 2
failure recovery, 301311
information about, 228229
listing available, 247249
MaxDB, 35
naming, 53
narrowing focus to, 126
planning for, 5361
preventative maintenance, 306307
privileges, 282
purpose of, 2
relational, 3
removing tables/records from, 108117
restoring, 301311
security, 278280
selecting, 249
showing, 1819, 126
simulating damage to, 307311
size of, 9, 23
speed considerations, 43
terminology, 23
Web Interface for, 254261
date functions, 164167, 175
DATE_FORMAT function, 164166, 175
dates, display of, 4851, 64
Debug Information option, 199
DELETE command, 108110, 115
DELETE FROM command, 114115
deleting items
data, 108117
with DELETE command, 108110, 115
with DELETE FROM command, 114115
dropping tables, 108, 110111, 116
emptying tables, 110
table data, 108109, 114116
truncating tables, 109110
users, 291
direct-data copy method, 296
disaster recovery, 301311
DISTINCT option, 123124, 130131
downloads
Linux systems, 2526
other systems, 35
overview, 3536
Windows systems, 10
drivers
MyODBC, 1922
MySQL, 814
DROP TABLE command, 108, 111, 116
dropping tables, 108, 110111, 116
DSN (Data Source Name), 272273