MySQL: Essential Skills

T

table copies, 296298

table types, 5661

tables

altering, 9192

backups , 292300

BDB, 56, 58, 60

changing data in, 95107

copying, 7880

creating, 6263

creating with existing table data, 8190

customizing data for specific needs, 120125

damaged, 302305

default, 3

deleting data in, 108109, 114116

description, 3, 53

dropping, 108, 110111, 116

formatting data in, 64

grant, 204, 285286

HEAP, 5657, 60

indexing. See indexes

information about, 229232

InnoDB, 56, 5960

inserting data into, 6776

ISAM, 5657

listing available, 247249

listing description of, 126

locking, 60

MERGE, 56, 5961

multiple, 183190

MyISAM, 5657, 5961

names , 5354, 7879

optimizing, 307

privileges, 207, 282

removing, 108117

restoring, 302, 307311

schema, 215216

showing all, 126

size of, 9

structure of, 9192

temporary, 60, 62, 7980, 287

transactional, 5859

truncating, 109110

unlocked, 305

varying-length, 46

tables_priv table, 286

tabs, importing and, 271

TAN function, 150

target parameter, 269

template files, 258259

TEMPORARY option, 62

TEMPORARY table type, 60

temporary tables, 60, 62, 7980, 287

terminology, 23

text data types, 4547

text files, 8081

themes, 224

threads, servers, 208

tilde (~), 27

time, display of, 4851

TIME data type, 4751

time functions, 164167

TIMESTAMP data type, 4950

TINYBLOB data type, 47

TINYINT data type, 56

TINYINT integer type, 4143

TINYTEXT data type, 47

transaction overhead, 58

transactional tables, 5859

trigonometry functions, 149150

TRIM function, 162163

TRUNCATE command, 109110, 115116, 305

TRUNCATE function, 152153

.txt extension, 80

type-casting functions, 259260