Index_F

F

Failed copying .frm file error message, 305

fetch method (Perl DBI), 608

fetchall() method (Python), 622–623

fetchall_arrayref method (Perl DBI), 608–609

fetchall_hashref method (Perl DBI), 609

FetchHashKeyName attribute
(Perl DBI), 611

fetchman() method (Python), 623

fetchone() method (Python), 623

fetchrow_array method (Perl DBI), 609

fetchrow_arrayref method (Perl DBI), 609

fetchrow_hashref method (Perl DBI), 609–610

FIELD() function, 530

field specification, 213

fields, 5

creating index from part, 141

names for, 246

PHP function to return contents, 591–592

PHP function to return information about, 579–584

PHP function to return number, 588–589

PHP function to return resource to list, 587

for related database tables, 4

term definition, 212

5th normal form, 234–236

FILE privilege, 435, 447, 488

files

redirecting output to, 103–105

running SQL statements stored in, 102–105

from command line, 104–105

find command (Windows), to locate data directory, 263

findColumn() method (Java), 634

FIND_IN_SET() function, 530

finish method (Perl DBI), 610

first() method (Java), 634

1st normal form, 226–227

fixed-length tables, 57

FLOAT column type, 43

FLOOR() function, 547

FLUSH PRIVILEGES statement, 425

FLUSH statement, 487–488

and replication, 343

flush variable, 380

Flush_commands variable, 388

flushing logs, 277

flush_time variable, 381

foreign keys, 215–216

and database design, 247

foreign_key info method (Perl DBI), 601

FORMAT() function, 547–548

format string, for date, 28

FOUND_ROWS() function, 562–563

4th normal form, 233–234

fragmentation of dynamic tables, 58

FreeBSD, starting MySQL in, 264, 265

.frm file extension, 263

FROM_DAYS() function, 517

FROM_UNIXTIME() function, 517–518

ft_boolean_syntax variable, 381

ft_max_word_len variable, 381

ft_max_word_len_sort variable, 381

ft_min_word_len variable, 381

full outer joins, 89

full table scan, 128

full-text index, 132–140

Boolean searches, 135–140

creating, 132–133

noise words, 133–134

relevance, 134–135

using, 133

func method (Perl DBI), 598

func table, 192

fields, 420

functions, 191

user-defined, 191–204