Index: C

Book Home

Symbols & Numbers | 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

Index: C

C API (see MySQL, C API)

C commenting: 15.1.3. Comments

C++ programming: 12. C API

Cache class: 9.3.2. Implementing the Model

9.3.2.9. The Cache class

cacheMode property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

cachePath property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

Cache.pm module: 9.3.2. Implementing the Model

caching data in applications: 5.2.1. Host Application Tuning

callproc( ) (MySQLdb module): 20.1.6. Cursor Methods

cardinality in relationships: 7.2.3. Relationships

caret (^), extended regular expression: 3.8.4. Pattern Matching

case sensitivity

MySQL extended regular expressions: 3.8.4. Pattern Matching

SQL: 3.1.2. The Design of SQL

15.1. Basic Syntax

CASE statement: 17.2.2. General Functions

Caucho JDBC driver: 13.1. The JDBC API

configuration information for: 13.1.2.2. Driver manager connectivity

CEILING( ) function: 17.2.2. General Functions

CGI module, Perl: 9.2. DBI and CGI

MVC methodology: 9.2.2. The Model/View/Controller Methodology
sample program: 9.2.3. A Sample CGI/DBI Program

CGI scripts and execution of arbitrary code: 6.2.3.3. Direct compromise

CHAR BINARY data type: 3.4.3. Binary Data Types

CHAR data type: 3.4. MySQL Data Types

16.2. String Data Types
19.1. Data Types
example of: 3.4.2. Character Types
storage space required by: 3.4.2. Character Types

CHAR( ) function: 17.2.2. General Functions

character data types: 3.4.2. Character Types

CHARACTER SET option (SET statement): 15.2. SQL Commands

character sets

adding through configuration: 14.2.1. Simple Character Sets

creating custom character sets: 3.7.3.2. Localized sorting

complex: 14.2.2. Complex Character Sets
simple: 14.2. Alternative Character Sets

editing array definitions: 14.2.1. Simple Character Sets

localized sorting and: 3.7.3.2. Localized sorting

mysql_character_set_name( ) and: 19.2. Functions

support for: 1.4. MySQL Features

characterEncoding property (GNU JDBC driver): 13.1.2.2. Driver manager connectivity

CHARACTER_LENGTH( ) function: 17.2.2. General Functions

CHAR_LENGTH( ) function: 17.2.2. General Functions

CHARSETS_AVAILABLE list: 14.2.1. Simple Character Sets

CHECK operation: 15.2. SQL Commands

CHECKSUM option: 15.2. SQL Commands

Christiansen, Tom: 9.3. A General Model for Maintainable Perl Programs

class methods: 9.3.1. A Model for Relational Data

Class.forName( ): 13.1.2.2. Driver manager connectivity

clean( ): 11.4. Securing User Data

cleaning up database applications: 8.2.1. Connections

13.2.2. Error Handling and Clean Up

client applications and security issues: 6.3.2. Client Applications

client hostnames, specifying: 6.1.2.1. GRANT and REVOKE

[client] section in configuration files: 4.1.2. File Content

client/server architecture

database applications and: 8.1.1. Client/Server Architecture
network security issues: 6.2.3. Network Security

close( ) (MySQLdb module): 10.1.1. The Database Connection

20.1.4. Connection Methods
20.1.6. Cursor Methods

close_api( ) support function: 12.2.1. Support Functions

COALESCE( ) function: 17.2.2. General Functions

Codd, Dr. E. F.: 3.1.1. The SQL Story

7.2. Normalization

columns

creating physical databases: 7.4.1. Tables and Columns
DESCRIBE statement and: 3.3. Table Management
ordering by: 3.7.3.1. Basic ordering
privileges that apply to: 6.1.2.1. GRANT and REVOKE
referencing: 15.1.2. Identifiers
specifying as AUTO_INCREMENT: 3.6.2. Sequence Generation
table creation and: 3.3. Table Management

columns_priv table: 6.1.2.2. The security tables

primary key of: 6.1.2.2. The security tables
schema for: 6.1.2.2. The security tables

command-line batch loads: 3.9.7.1. Command-line loads

COMMENT option: 15.2. SQL Commands

comments

in configuration files: 4.1.2. File Content
in PHP scripts: 11.1.1. A Short Language Primer
used in SQL: 15.1.3. Comments

COMMIT command: 3.9.2. Transactions

commit( ) (MySQLdb module): 20.1.4. Connection Methods

comparison operators: 3.8. SQL Operators

17.1.3. Comparison Operators

compiling queries: 5.2.2.2. EXPLAIN SELECT

compound variable types in PHP: 11.1.1. A Short Language Primer

Comprehensive Perl Archive Network (CPAN): 9.1.2. Setting Up the Database and Program

compromising individual services and network security: 6.2.3.3. Direct compromise

CONCAT( ) function: 17.2.2. General Functions

CONCAT_WS( ) function: 17.2.2. General Functions

conditionals in PHP: 11.1.1. A Short Language Primer

configuration files

contents of: 4.1.2. File Content
on Unix systems: 4.1.1. File Locations
on Windows systems: 4.1.1. File Locations

configure utility (MySQL): 2.2.3. Source Distributions

configure.in file: 14.2.1. Simple Character Sets

configuring MySQL: 4.1. Configuration

connect( ): 9.1.1. Basic Perl Example

attributes for error handling: 9.1.3. Error Handling and Attributes
connecting to databases using Python DB-API: 10.1.1. The Database Connection

Connection interface: 13.1.2. Connecting to MySQL

getConnection( ) and: 13.1.2.2. Driver manager connectivity

connection pooling as performance tuning tool: 5.2.1. Host Application Tuning

connection resource handles: 11.3.2. Opening and Using a Database Connection

18.1. Data Types

CONNECTION_ID( ) function: 17.2.2. General Functions

connections: 19.2. Functions

(see also mysql_connect(; mysql_pconnect( )))
access to MySQL using security tables: 6.1.2.2. The security tables
in C: 12.1.1. The Connection
increasing performance by reducing numbers of: 5.2.1. Host Application Tuning
in Java: 13.1.2. Connecting to MySQL
managing for database applications: 8.2.1. Connections
mysql_real_connect( ) and: 19.2. Functions
in Perl: 9.1.1. Basic Perl Example
in PHP: 11.3.2. Opening and Using a Database Connection
in Python: 10.1.1. The Database Connection

connectionTimeout property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

const join type: 5.2.2.2. EXPLAIN SELECT

constructor methods: 9.3.2. Implementing the Model

9.3.2.6. Constructors

containment relationship: 9.3.1. A Model for Relational Data

Controller layer (MVC methodology): 9.2.2. The Model/View/Controller Methodology

9.3.3. Example of the Model's Use

controller logic: 9.3.3. Example of the Model's Use

Controller layer in MVC methodology: 9.2.2. The Model/View/Controller Methodology
in web architecture: 8.1.1.2. Fat and thin clients

CONV( ) function: 17.2.2. General Functions

cookies: 11.5. Managing Sessions

$HTTP_COOKIE_VARS array and: 11.4. Securing User Data

core files and security issues: 6.3.1.2. Resource protection

COS( ) function: 17.2.2. General Functions

COT( ) function: 17.2.2. General Functions

COUNT( ) function: 17.2.1. Aggregate Functions

country-code standards: 3.4.2. Character Types

CPAN (Comprehensive Perl Archive Network): 9.1.2. Setting Up the Database and Program

"crash-me" test suite: 1.4. MySQL Features

CREATE DATABASE statement: 3.2. Database Creation

15.2. SQL Commands

CREATE FUNCTION statement: 15.2. SQL Commands

15.2. SQL Commands
loading a new UDF (user-defined function): 14.1.3. Calling a UDF

CREATE INDEX statement: 3.5. Indexing

15.2. SQL Commands
ending transactions with: 3.9.2. Transactions

create method (Model class): 9.3.1. A Model for Relational Data

CREATE privilege: 6.1.2.1. GRANT and REVOKE

create( ) (Publisher class): 9.3.2. Implementing the Model

9.3.2.2. Methods that build and execute SQL

CREATE TABLE statement: 3.3. Table Management

7.4.2. Foreign Keys
15.2. SQL Commands
full text searching and: 3.9.1.1. The Basics
index creation and: 3.5. Indexing
table options for: 15.2. SQL Commands

createStatement( ): 13.2. Simple Database Access

scrollable result sets and: 13.2.1. Queries and Result Sets

cresource data type (PHP): 18.1. Data Types

cross-database joins in MySQL: 1.4. MySQL Features

CROSS keyword: 15.2. SQL Commands

crypt( ): 11.7. Using the HTML <form> Environment

ctype array

complex character sets: 14.2.2. Complex Character Sets
simple character sets: 14.2.1. Simple Character Sets

ctype-<Emphasis>charset<Default Para Font>.c file: 14.2.2. Complex Character Sets

CURDATE( ) function: 17.2.2. General Functions

CURRENT_DATE( ) function: 17.2.2. General Functions

CURRENT_TIME( ) function: 17.2.2. General Functions

CURRENT_TIMESTAMP( ) function: 17.2.2. General Functions

cursor attributes of MySQLdb module: 20.1.5. Cursor Attributes

cursor methods of MySQLdb module: 20.1.6. Cursor Methods

cursor( ) (MySQLdb module): 10.1.2. Cursors

20.1.4. Connection Methods

cursors in Python DB-API: 10.1.2. Cursors

CURTIME( ) function: 17.2.2. General Functions

Symbols & Numbers | 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