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]

back_log 2nd

back_log system variable backslash (

backslash (/), division operator 2nd BACKUP TABLE 2nd 3rd 4th 5th 6th

BACKUP TABLE statement 2nd backups 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 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th 99th 100th 101st 102nd 103rd 104th 105th 106th 107th 108th 109th 110th 111th 112th 113th 114th 115th 116th 117th 118th 119th 120th 121st 122nd 123rd 124th 125th 126th 127th 128th 129th 130th 131st 132nd 133rd 134th 135th 136th 137th 138th 139th 140th 141st 142nd 143rd 144th 145th 146th 147th 148th 149th 150th 151st 152nd 153rd 154th 155th 156th 157th 158th 159th 160th 161st 162nd 163rd 164th 165th 166th 167th 168th 169th 170th 171st 172nd 173rd 174th 175th 176th

backward compatibility, configuring for 2nd 3rd 4th 5th 6th

bail_out() method 2nd 3rd

base directory installation, checking

basedir 2nd basedir system variable batch files 2nd 3rd

Batch mode 2nd 3rd

Batch mode (mysql) 2nd 3rd

BDB 2nd 3rd 4th 5th 6th 7th 8th

BDB (Berkeley DB) storage engine BDB options 2nd 3rd 4th

BDB storage engine 2nd 3rd 4th 5th

BDB storage engines 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th BDB table auto-recovery problems 2nd 3rd 4th

BDB tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd bdb-logdir option

bdb_cache_size 2nd

bdb_cache_size system variable

bdb_home 2nd 3rd 4th

bdb_home system variable 2nd

bdb_log_buffer_size 2nd

bdb_log_buffer_size system variable

bdb_logdir 2nd

bdb_logdir system variable

bdb_max_lock 2nd

bdb_max_lock system variable

bdb_shared_data 2nd

bdb_shared_data system variable

bdb_tmpdir 2nd

bdb_tmpdir system variable

BDMPOLYFROMTEXT() function

BDMPOLYFROMWKB() function 2nd 3rd 4th BDPOLYFROMTEXT() function BDPOLYFROMWKB() function 2nd 3rd 4th

BEFORE trigger

BEFORE triggers BEGIN 2nd 3rd

BEGIN É END 2nd 3rd

BEGIN É END statement

BEGIN statement

begin_work 2nd

begin_work database handle method (Perl DBI)

BENCHMARK() function benefits of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

BETWEEN comparison operator 2nd big_tables 2nd

big_tables session-only system variable BIGINT 2nd

BIGINT integer data type

BIN() function

binary 2nd 3rd 4th 5th 6th

BINARY 2nd 3rd 4th 5th 6th binary backups 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 binary backups, BDB tables 2nd 3rd 4th

binary backups, complete binary backups 2nd 3rd 4th

binary backups, creating 2nd

binary backups, creating via replication slaves 2nd 3rd 4th

binary backups, InnoDB tables 2nd 3rd 4th binary backups, mysqlhotcopy utility 2nd 3rd 4th

binary backups, partial binary backups 2nd 3rd 4th

binary backups, renaming databases 2nd BINARY binary data type 2nd

BINARY cast operator binary data 2nd 3rd 4th 5th 6th 7th

binary data in SQL statements 2nd

binary data, printing 2nd

binary distributions 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

binary log contents 2nd

binary log index files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

binary logs 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

binary logs, displaying contents 2nd

binary logs, displaying contents of

binary logs, system backups 2nd

BINARY operator

binary portability 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

binary portability (tables) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

binary string 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

BINARY string data type

binary 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 41st 42nd 43rd 44th 45th 46th 47th 48th

binary string data types, BINARY binary string data types, BLOB 2nd 3rd 4th binary string data types, corresponding nonbinary string data types 2nd

binary string data types, ENUM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

binary string data types, SET 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th binary string data types, value storage

binary string data types, VARBINARY

binary string, BINARY 2nd

binary string, BLOB 2nd 3rd

binary string, LONGBLOB 2nd

binary string, MEDIUMBLOB

binary string, TINYBLOB binary string, VARBINARY 2nd 3rd

binary 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 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd binary strings, case sensitivity

binary strings, collations binary strings, hexadecimal constants

binary strings, properties of 2nd 3rd

bind_col()

bind_col() method

bind_col() statement handle method (Perl DBI) bind_columns() 2nd bind_columns() method

bind_columns() statement handle method (Perl DBI) 2nd

bind_param() 2nd

bind_param() statement handle method (Perl DBI) 2nd

bind_param_array() bind_param_array() statement handle method (Perl DBI)

binlog-ignore-db option

Binlog_cache_disk_use 2nd Binlog_cache_disk_use status variable

binlog_cache_size 2nd 3rd 4th binlog_cache_size system variable 2nd

Binlog_cache_use 2nd

Binlog_cache_use status variable

bit 2nd 3rd 4th

BIT 2nd

bit 2nd 3rd

BIT data type 2nd

BIT data types 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

bit operator

bit operators 2nd 3rd 4th 5th

BIT_AND() function

BIT_COUNT() function

BIT_LENGTH() function

BIT_OR() function

BIT_XOR() function

BLOB 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

BLOB binary data type 2nd 3rd BLOB columns 2nd 3rd BLOB string data type 2nd 3rd 4th

BLOB values, retrieving

BLOB, handling trailing spaces BLOB/TEXT columns 2nd 3rd 4th

BLOB/TEXT columns, segregating 2nd

BLOB/TEXT values, retrieving

block_size values 2nd

Boolean mode searches 2nd 3rd 4th 5th 6th 7th 8th

Boolean mode searches (FULLTEXT searches) 2nd 3rd 4th

boolean operators [See logical operators] BOUNDARY() function

buffer members 2nd buffer_length members 2nd

buffer_type members 2nd building 2nd

building MySQL programs 2nd

bulk_insert_buffer_size 2nd

bulk_insert_buffer_size system variable

byte string data types [See binary string data types] Bytes_received 2nd Bytes_received status variable

Bytes_sent 2nd

Bytes_sent status variable