Index: T

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

\t escape sequence (MySQL): 15.1.1. Literals

tab delimited data, exporting: 15.2. SQL Commands

table column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT

table types: 15.2. SQL Commands

transactional: 3.9.2. Transactions

8.2.2. Transactions

table_cache variable: 5.3. Database Server Tuning

tables: 1.1. Relational Databases

adding rows to: 3.6.1. Inserts

auto-incrementing columns: 3.6.2. Sequence Generation

checking: 4.6.1. Checking a Table

creating: 3.1.2. The Design of SQL

3.3. Table Management
9.1.2. Setting Up the Database and Program

creating physical databases: 7.4.1. Tables and Columns

deleting from databases: 3.3. Table Management

6.1.2.1. GRANT and REVOKE

deleting rows from: 3.6.5. Deletes

6.1.2.1. GRANT and REVOKE

detecting errors: 4.6. Table Maintenance and Crash Recovery

full table scans vs. indexes: 5.2.2.1. Index guidelines

indexes (see indexes on tables)

joining: 3.7.1. Joins

15.2. SQL Commands
object/relational modeling: 8.3. Object/Relational Modeling

locking: 3.9.3. Table Locking

15.2. SQL Commands

managing: 3.3. Table Management

MySQL types: 15.2. SQL Commands

MYSQL_FIELD data type and: 19.1. Data Types

outer joins: 3.9.5. Outer Joins

performance tuning for: 5.2.1. Host Application Tuning

privileges that apply to: 6.1.2.1. GRANT and REVOKE

referencing: 15.1.2. Identifiers

relationships between: 9.3.1. A Model for Relational Data

repairing errors: 4.6.2. Repairing a Table

scheduled checking: 4.6.3. Scheduled Table Checking

security: 6.1.2. Privilege Management

6.1.2.2. The security tables

for storing users: 6.3.1.1. User management

unlocking: 3.9.3. Table Locking

15.2. SQL Commands

updating: 15.2. SQL Commands

tables_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

TAN( ) function: 17.2.2. General Functions

tar utility

binary distributions, installing: 2.2.1. Binary (Tarball) Distributions
source distributions, installing: 2.2.3. Source Distributions

tarball distributions (see binary distributions)

TcX: 1.2. The History of MySQL

Template Toolkit module: 9.2.3. A Sample CGI/DBI Program

test suite for MySQL ("crash-me"): 1.4. MySQL Features

testing environment (QA): 6.1.1. User Management

TEXT data type: 3.4. MySQL Data Types

16.2. String Data Types
19.1. Data Types
IS_BLOB( ) macro: 19.1. Data Types
storage space required by: 3.4.2. Character Types

text elements, searching on: 3.9.1. Full Text Searching

thin and fat clients: 8.1.1.2. Fat and thin clients

third normal form (3NF): 7.2.8. Third Normal Form

Thomas, Deepak: 11.8. Where to Find Out More

Thomson, Laura: 11.8. Where to Find Out More

thread IDs of current connection, returning: 19.2. Functions

threadsafety attribute (MySQLdb module): 20.1.1. Module Attributes

three-tier application models (MVC methodology): 9.2.2. The Model/View/Controller Methodology

tilde (~), in Boolean mode searches: 3.9.1.3. Boolean mode

TIME data type: 3.4. MySQL Data Types

16.3. Date Data Types
19.1. Data Types

Time object (Python DB-API): 10.1.4. Other Objects

TIME_FORMAT( ) function: 17.2.2. General Functions

TimeFromTicks( ): 10.1.4. Other Objects

timeouts for sessions: 11.5. Managing Sessions

TIMESTAMP data type: 3.4.5. Other Kinds of Data

16.3. Date Data Types
19.1. Data Types

Timestamp object (Python DB-API): 10.1.4. Other Objects

TIMESTAMP option (SET statement): 15.2. SQL Commands

TimestampFromTicks( ): 10.1.4. Other Objects

TIME_TO_SEC( ) function: 17.2.2. General Functions

TINYBLOB data type: 3.4.3. Binary Data Types

16.2. String Data Types

TINYINT data type: 16.1. Numeric Data Types

19.1. Data Types

TINYTEXT data type: 16.2. String Data Types

storage space required by: 3.4.2. Character Types

TO_DAYS( ) function: 3.9.4.1. Date functions

17.2.2. General Functions

to_lower array

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

to_upper array

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

transaction isolation levels: 8.2.2.1. Transaction isolation levels

transaction management: 3.9.2. Transactions

database applications and: 8.2.2. Transactions
pros/cons for MySQL: 1.3. MySQL Design

transactional table types: 3.9.2. Transactions

8.2.2. Transactions

TRIM( ) function: 3.9.4.2. String functions

17.2.2. General Functions

TRUNCATE( ) function: 17.2.2. General Functions

TRUNCATE statement: 15.2. SQL Commands

ending transactions with: 3.9.2. Transactions

twz JDBC driver: 13.1. The JDBC API

configuration information for: 13.1.2.2. Driver manager connectivity
properties for: 13.1.2.2. Driver manager connectivity

type column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT

TYPE option: 15.2. SQL Commands

type_conv attribute (MySQLdb module): 20.1.1. Module Attributes

Types 1-4 JDBC drivers: 13.1. The JDBC API

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