Index_N

N

Name attribute (Perl DBI), 614

NAME attribute (Perl DBI), 614

named commands, mysql command option to enable/disable, 53

named pipes, for client access to server, 263

NAME_hash attribute (Perl DBI), 615

NAME_lc attribute (Perl DBI), 615

NAME_lc_hash attribute (Perl DBI), 615

NAME_uc_hash attribute (Perl DBI), 615

NATIONAL keyword, 48

nativeSQL() method (Java), 628

natural joins, and USING keyword, 90–91

neat method (Perl DBI), 599

neat_list method (Perl DBI), 599

net_buffer_length variable, 385

net_read_timeout variable, 385

net_retry_count variable, 385

net_write_timeout variable, 385

next() method (Java), 637

nextset() method (Python), 623

noise words, in full-text search, 133–134

normalization, 219–236

1st normal form, 226–227

2nd normal form, 227–228

3rd normal form, 228–229

4th normal form, 233–234

5th normal form and beyond, 234–236

Boyce-Codd normal form, 229– 232

and denormalization, 236–237

NOT BETWEEN comparison operator, 70

NOT IN comparison operator, 71

NOT LIKE comparison operator, 71

NOT, ! logical operator, 68, 500

NOT REGEXP, NOT RLIKE comparison operator, 71

Not_flushed_delayed_rows variable, 389

Not_flushed_key_blocks variable, 389

NOW() function, 28–29, 35, 519

NULL values, 27, 213

and comparison operators, 72–73

in foreign key, 245–246

and primary key, 129

NULLABLE attribute (Perl DBI), 615

NULLIF() function, 567

NUMERIC column type, 44

numeric column types, 42–45

numeric functions, 544–554

ABS, 544

ACOS, 544

ASIN, 544

ATAN, 545

ATAN2, 545

CEILING, 545

COS, 545–546

COT, 546

DEGREES, 546

EXP, 546–547

FLOOR, 547

FORMAT, 547–548

GREATEST, 548

LEAST, 548–549

LN, 549

LOG, 549

LOG2, 550

LOG10, 549

MOD, 550

PI, 550–551

POW, 551

POWER, 551

RADIANS, 551

RAND, 551–552

ROUND, 552

SIGN, 553

SIN, 553

SQRT, 553

TAN, 553–554

TRUNCATE, 554

NUM_OF_FIELDS attribute (Perl DBI), 616

NUM_OF_PARAMS attribute (Perl DBI), 616