MySQL: Essential Skills

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