Index_O

O

OCT() function, 536–537

OCT_LENGTH() function, 537

ODBC (Open Database Connectivity), 663

and data sources, 663–665

connection options, 665

setup, 664

MyODBC functions, 672–690

using, 666–672

ADO VB example, 669–670

C# example, 668–669

DAO VB example, 671–672

.NET VB example, 666–667

RDO VB example, 670–671

ON DELETE CASCADE, 246

ON DELETE RESTRICT, 246

one-to-many relationship, 213, 213, 243, 243

one-to-one relationship, 213, 213, 243, 243

open source, 3

Opened_tables variable, 389

Open_files variable, 389

open_files_limit variable, 385

Open_streams variable, 389

open_tables variable, 367

Open_tables variable, 389

operating systems, binary distribution of MySQL available for, 452

operation phase of database lifecycle, 249

example, 255–256

operators in MySQL

arithmetic operators, 500–502

bit operators, 509–511

&, 510

|, 510

<<, 510

>>, 511

comparison operators, 502–509

BETWEEN, 506

IN, 507

!=, <>, 503

<, 504

<=>, 505

<=, 505

=, 502–503

>, 504

>=, 504–505

IS NULL, 505–506

LIKE, 506–507

REGEXP, RLIKE, 507–509

logical operators, 499–500

AND, &&, 499

NOT, !, 500

OR, ||, 500

operators in SQL, 67–84

arithmetic operators, 69–70

bit operators, 79–84

comparison operators, 70–79

LIKE clause, 74–75

logical operators, 68

regular expressions, 75–79

optimal compiles for MySQL, 461

OPTIMIZE statement, 280, 491

optimizing MySQL configuration

back_log variable, 373

delayed_queue_size variable, 373

hardware improvements for, 393–394

key_buffer_size variable, 368

max_connections variable, 368–373

sort_buffer variable, 373

table_cache variable, 367–368

optimizing tables

with myisamchk utility, 281–282

with mysqlcheck utility, 281

with OPTIMIZE statement, 280

optional relationship, 214

OR, || logical operator, 68, 500

OR keyword, in SELECT statement, 14

ORD() function, 537

order of precedence, for permission tables, 422

ordinary index, creating, 131–132

organization culture, and database requirements, 240–241

outer joins

full, 89

left, 87–89

right, 89

outfile, mysql command option for, 54

output, redirecting to file, 103–105

owner-member relationship in network database model, 211