Index_C

C

C API, 645–662

data types, 645–648

example, 661–662

functions, 648–661

CachedKids attribute (Perl DBI), 610

calculations

and database design, 246

in SELECT statement, 161–163

cancelRowUpdates() method (Java), 634

candidate key, 214, 232

"Can't start server: Bind on TCP/IP port" error message, 464

"Can't start server: Bind on unix socket" error message, 464

cardinality, 169, 244

cascading deletes and updates, 216

case, and comparison operators, 72

CASE() function, 558–559

CAST() function, 559–560

CEILING() function, 545

CHANGE MASTER TO statement, 342–343

CHAR column type, 46, 47

full-text index for, 132

index for, 141

vs. VARCHAR, 48

CHAR() function, 526

character set, 409–413

PHP function to return default, 573

CHARACTER_LENGTH() function, 526

character_set variable, 380

character_sets variable, 380

CHAR_LENGTH() function, 526

checking tables

with CHECK TABLE statement, 285–286, 483

with myisamchk utility, 287–288

with mysqlcheck utility, 286–287

ChopBlanks attribute (Perl DBI), 611

clearBatch() method (Java), 629

clearWarnings() method (Java), 627, 629

close() method (Java), 627, 629, 634

close() method (Python), 621, 622

Codd, E.F., 211, 229

coding phase of application development, 187–188

column types, 10, 213

date and time column types, 50– 52

numeric, 42–45

string, 45–50

column_info method (Perl DBI), 600

columns in database table, 5

adding new, 25

changing definition, 25–26

CONCAT() function to join, 30

dropping, 26

new heading for, 30

types, 41–52

date and time, 50–52

numeric, 42–45

string, 45–50

columns_priv table

fields, 419–420

and user permissions, 422

command line prompt, 6

comments

in program code, 187

in Windows startup configuration file, 271

commit() method (Java), 627

commit method (Perl DBI), 600

commit() method (Python), 621

COMMIT statement, 105, 483

automatic, 112–115

comparison operators in SQL, 70–79, 502–509

!=, <>, 70, 503

<, 70, 504

=, 71–72, 502–503

>, 70, 504

<=, 70, 505

<=>, 70, 505

>=, 70, 504–505

BETWEEN, 506

IN, 71, 74, 507

IS NOT NULL, 70

IS NULL, 505–506

LIKE, 16–17, 74–75, 506–507

REGEXP, RLIKE, 70, 71,
507–509

vs. regular expressions, 76

CompatMode attribute (Perl DBI), 611

compiling

avoiding common problems, 465

MySQL optimally, 461

user-defined functions, 192–194

composite entity type, 244

compressed tables, 58–60

compression, mysql command option for, 52

Com_[statement] variable, 388

CONCAT() function, 30, 526–527

CONCAT_WS() function, 527–528

conceptual design phase, 242–245

CONCURRENT keyword, for LOAD DATA statement, 324

concurrent_inserts variable, 380

.conf file for character set, 411–413

config.cache file, and recompiling, 465

connect method (Perl DBI), 596–597

connect() method (Python), 620–621

connect_cached method (Perl DBI), 597

connection to MySQL server, 5–7, 6

persistent, 176, 369

PHP function to establish, 589–590

PHP function to close, 573

PHP function to establish, 573–574

PHP function to return information about, 585

with Secure Socket Layer, 447– 448

security when, 415–416

CONNECTION_ID() function, 560

Connections variable, 388

connectivity, 244

connect_timeout variable, 380

consistency of transactions, 256

consistent reads, with InnoDB tables, 107–108

constraints, 247

CONV attribute (Python), 619

CONV() function, 528–529

CONVERT() function, 560

copying files for backups, of MyISAM tables, 307–309

COS() function, 545–546

COT() function, 546

COUNT() function, 21–22, 556

CPU (central processing unit), and performance, 394

crash-me script, 399–408

options, 399–400

CREATE DATABASE statement, 7

CREATE FUNCTION statement, 194

CREATE INDEX statement, 131

and transaction completion, 117

CREATE privilege, 435, 488

CREATE statement, 483–486

CREATE TABLE statement, 9–10

for full-text index creation, 132

and ordinary index creation, 131

PRIMARY KEY keyword in, 129

CREATE TEMPORARY TABLES privilege, 435, 488

Created_tmp_disk_tables variable, 388

Created_tmp_files variable, 388

Created_tmp_tables variable, 388

createStatement() method (Java), 627

CURDATE() function, 512

CURRENT_DATE() function, 28–29, 512

CURRENT_TIME() function, 512–513

CURRENT_TIMESTAMP() function, 513

cursor() method (Python), 621

CursorName attribute (Perl DBI), 614

CURTIME() function, 513



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net