Index_D


D

dash (-), 63
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 data type, 49
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
database parameter, 249
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
Databases tab, 1819
DATE data type, 4751, 56
date functions, 164167, 175
date/time fields, 4751
DATE_FORMAT function, 164166, 175
dates, display of, 4851, 64
DATETIME data type, 49
DAYNAME function, 167
DAYOFWEEK function, 167
DAYOFYEAR function, 167
days, display of, 4851
DB library, 267
db table, 285
Debug Information option, 199
DECIMAL data type, 44
decimals, 4445
DEGREES function, 149
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
DESC command, 73, 126
design concepts, 258259
direct-data copy method, 296
directory options, 201
disaster recovery, 301311
disk space, 9
DISTINCT option, 123124, 130131
.doc files, 80
documentation, 3637
dollar sign ($), 334338
DOUBLE data type, 4445
double quotes, 335
downloads
Linux systems, 2526
other systems, 35
overview, 3536
Windows systems, 10
drivers
MyODBC, 1922
MySQL, 814
drop-down menus , 51
DROP option, 9192
DROP privilege, 288
DROP TABLE command, 108, 111, 116
dropping tables, 108, 110111, 116
DSN (Data Source Name), 272273
DSN connections, 273275
dsn parameter, 267
dual-license paradigm, 5



MySQL(c) Essential Skills
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
Year: 2006
Pages: 109

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net