MySQL: Essential Skills

C

cache, 203

Cartesian join, 184185

case sensitivity, 135, 333

CASE value, 145

CASE...WHEN function, 145147, 168, 171172

catalog information, 215216

CEILING function, 152

CHANGE option, 91

CHAR data type, 4546

CHAR function, 164

character set options, 204

characters

escape, 335336

length of, 4546

special, 335, 285

CHECK TABLE command, 303

client-access security, 280281

clients . See also MySQL Client

access to, 280281

information about, 197

security, 280281

coding

HTML, 258259

logic, 258259

PHP, 243

column-level privileges, 282

columns . See also fields

adding headings, 124125

copying, 79

defining, 62

described, 23

grouping, 177179

nongrouping, 177179

privileges, 207

renaming, 124125

columns_priv table, 286

comma-delimited files, 80, 272

comma delimiters, 272

command line, 2835

commands. See also specific commands

correcting mistakes in, 6364

date/format, 175

comments, 243, 254, 333, 337

COMMIT statement, 60

comparison operators, 339

comparison string functions, 159160

compression protocol, 196

CONCAT function, 154156, 173174

concatenation operator, 339

CONCAT_WS function, 156

configuration files, 199

connect () function, 267

Connection Usage setting, 210

connections

DSN, 273275

information about, 210

MySQL Administrator, 194197

passwords, 195

server, 207209

users, 209

Connector/ODBC, 9

Console Manager, 224234

control flow functions, 145147

control structures, 342345

copying

columns, 79

selected data, 80

tables, 7880

to temporary table, 7980

COS function, 150

COT function, 150

COUNT function, 147148

CREATE DATABASE command, 62, 65

CREATE INDEX command, 9394

CREATE TABLE command, 6263, 66

curly braces { }, 281