Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

NAME

name columns name columns (grade-keeping table database scenario student tables

name conventions 2nd 3rd 4th name member 2nd

NAME statement handle attribute (Perl DBI) NAME_hash 2nd

NAME_hash statement handle attribute (Perl DBI) 2nd

NAME_lc

NAME_lc statement handle attribute (Perl DBI)

NAME_lc_hash NAME_lc_hash statement handle attribute (Perl DBI) NAME_uc

NAME_uc statement handle attribute (Perl DBI)

NAME_uc_hash

NAME_uc_hash statement handle attribute (Perl DBI)

named_pipe 2nd named_pipe system variable

names 2nd 3rd 4th 5th 6th

names, case sensitivity 2nd naming 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th

naming column values 2nd 3rd 4th 5th 6th 7th 8th 9th naming column vlaues 2nd 3rd

naming conventions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st

naming conventions, case sensitivity 2nd 3rd

naming schemes 2nd 3rd 4th

naming TEMPORARY tables 2nd

native packaging formats

natural language searches 2nd 3rd 4th 5th 6th 7th 8th

natural language searches (FULLTEXT searches) 2nd 3rd 4th

natural left

NATURAL LEFT JOIN clause 2nd

natural left joins

NDB

NDB storage engine

NDB storage engines 2nd 3rd

neat() 2nd 3rd 4th 5th 6th

neat() function (Perl DBI) 2nd

neat_list() 2nd 3rd neat_list() function (Perl DBI) net_buffer_length 2nd

net_buffer_length system variable

net_buffer_length variable 2nd net_read_timeout 2nd

net_read_timeout system variable

net_retry_count 2nd

net_retry_count system variable

net_write_timeout 2nd

net_write_timeout system variable

network connections 2nd 3rd network connections, listening for 2nd 3rd 4th 5th 6th

network transfers 2nd new 2nd

new system variable nextId() 2nd

nextId() method (PEAR DB module)

no result set returned SQL statements 2nd 3rd 4th

no result set returned statements 2nd 3rd 4th

no result set statements 2nd 3rd 4th 5th 6th 7th 8th 9th no result set statements, do() method 2nd 3rd NO_AUTO_CREATE_USER SQL mode 2nd 3rd 4th

NO_AUTO_CREATE_USER SQL mode value

NO_AUTO_CREATE_USER value 2nd

NO_AUTO_VALUE_ON_ZERO SQL mode value 2nd

NO_AUTO_VALUE_ON_ZERO value 2nd 3rd 4th NO_BACKSLASH_ESCAPES SQL mode value

NO_BACKSLASH_ESCAPES value 2nd

NO_DIR_IN_CREATE SQL mode value NO_DIR_IN_CREATE value 2nd

NO_FIELD_OPTIONS SQL mode value NO_FIELD_OPTIONS value 2nd

NO_KEY_OPTIONS SQL mode value

NO_KEY_OPTIONS value 2nd

NO_TABLE_OPTIONS SQL mode value

NO_TABLE_OPTIONS value 2nd

NO_UNSIGNED_SUBSTRACTION SQL mode value

NO_UNSIGNED_SUBTRACTION value 2nd

NO_ZERO_DATE attribute

NO_ZERO_DATE SQL mode value

NO_ZERO_DATE value 2nd

NO_ZERO_IN_DATE attribute

NO_ZERO_IN_DATE SQL mode value

NO_ZERO_IN_DATE value 2nd

Noinstall packages

Noinstall packages (MySQL 4.1.5)

nonbinary string 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th

nonbinary string data types 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th nonbinary string data types, CHAR 2nd 3rd 4th 5th nonbinary string data types, corresponding binary string data types 2nd

nonbinary string data types, TEXT 2nd 3rd

nonbinary string data types, value storage nonbinary string data types, VARCHAR 2nd 3rd 4th 5th

nonbinary string, CHAR 2nd 3rd

nonbinary string, LONGTEXT 2nd

nonbinary string, MEDIUMTEXT

nonbinary string, TEXT 2nd 3rd

nonbinary string, TINYTEXT 2nd

nonbinary string, VARCHAR 2nd nonbinary strings 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd

nonbinary strings, collations 2nd nonbinary strings, properties of 2nd

nonmatching value selections 2nd 3rd 4th nonrepeatable reads 2nd 3rd 4th 5th 6th

nonrepeatable reads (transactions) 2nd 3rd

nonscalar 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th

nonscalar data types (C API) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

nontransactional alternatives 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th nontransactional alternatives, explicit table locking 2nd nontransactional alternatives, relative updates versus absolute updates

nopager command

NOT EXISTS subqueries 2nd 3rd 4th 5th 6th

NOT IN subqueries 2nd 3rd 4th

NOT LIKE operators NOT LIKE pattern-matching operator

NOT logical operator

NOT NULL columns 2nd NOT NULL, defining as (query optimization)

NOT REGEXP pattern-matching operator NOT RLIKE pattern-matching operator

Not_flushed_delayed_rows 2nd

Not_flushed_delayed_rows status variable

Not_flushed_keyed_blocks 2nd

Not_flushed_keyed_blocks status variable

notee command

notify_member() function 2nd 3rd

NOW() function 2nd

NULL

NULL data types

NULL value testing 2nd

NULL values 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th

NULLABLE 2nd

NULLABLE statement handle attribute (Perl DBI) 2nd

NUM_OF_FIELDS

NUM_OF_FIELDS statement handle attribute (Perl DBI)

NUM_OF_PARAMS NUM_OF_PARAMS statement handle attribute (Perl DBI) numbered log files 2nd 3rd 4th

numbered log files, expiring 2nd

numbred log files 2nd numCols() 2nd

numCols() method

numcols() method

numCols() method

numCols() method (PEAR DB module)

numeric 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd

numeric arguments 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th numeric data types 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th

numeric functions 2nd 3rd 4th 5th 6th 7th 8th 9th numeric values 2nd

numeric values, handling 2nd 3rd NUMGEOMETRIES() function

NUMINTERIORRINGS() function

NUMPOINTS() function

numRows()

numRows() method 2nd numRows() method (PEAR DB module)