MySQL: Essential Skills

S

safe-updates option, 9798

schema, 215

schema privileges, 207

schema tables, 215216

schemata , 215

SCO systems, 3536

seconds, display of, 4851

security

changing ports, 24

client-access, 280281

databases, 278280

files, 280

levels of, 278281

log files, 280

MySQL Administrator, 204

SQL injection and, 351

web and, 259261

security- related functions, 204

SELECT command

described, 120

limiting selections with, 121123

problems with, 121

reading tables into other tables, 68

shaping data with, 123125

temporary tables, 80

testing with, 120123

viewing tables, 7172

SELECT INTO OUTFILE function, 271

SELECT...FROM command, 73

SELECT...WHERE command, 129138

semicolon (;), 30, 3334, 63

separators, 156

Server Administration settings, 232234

server logs, 211212

server parameter, 245

Server tab, 17

servers. See also MySQL Server

connections, 207209

information about, 197, 227228

status of, 197

threads, 208

Service Control functions, 197200

SET data type, 5152

SET type, 149

SHOW command, 73

SHOW DATABASES command, 126

SHOW TABLES command, 66, 126, 309

SHUTDOWN privilege, 288

SIGN function, 152

signed integers, 4142

Simple Object Access Protocol (SOAP), 242

SIN function, 150

single quotes ('), 271, 335

Slow Queries Log field, 212

SMALLINT integer type, 4143

SOAP (Simple Object Access Protocol), 242

software. See applications

Solaris systems, 3536

spaces

errors and, 89

extra, 8990

importing and, 271

special characters , 285, 335

SQL injections, 262, 351

sql parameter, 249250

SQRT function, 150152

square brackets, 98

Start Check tab, 17

Startup Variables functions, 200205

Status Variables settings, 210

STD function, 149

STDDEV function, 149

STRCMP function, 159, 161

string functions, 155164

string values, 51

STRING variables, 335336

strings

comparing, 159160

concatenating, 154156

date-related, 164167

described, 45

length of, 158

manipulating, 155164

null-related functions, 167169

padding, 161162

quotation marks and, 64

random, 154

repeating, 161

replacing, 157158

reversing, 161

substrings, 156157

trimming, 162163

use of, 142

SUBSTRING function, 156

SUBSTRING_INDEX function, 156158

SUM function, 147148, 172

SUPER privilege, 288

SWITCH control structure, 344345

system failure, 292293

system information, 210211

system requirements

Linux platform, 25

Windows platform, 89

System Variables settings, 210211