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