S
safe-updates option, 9798
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
Server Administration settings, 232234
servers. See also MySQL Server
connections, 207209
information about, 197, 227228
status of, 197
threads, 208
Service Control functions, 197200
SHOW DATABASES command, 126
SHOW TABLES command, 66, 126, 309
Simple Object Access Protocol (SOAP), 242
single quotes ('), 271, 335
Slow Queries Log field, 212
SMALLINT integer type, 4143
SOAP (Simple Object Access Protocol), 242
software. See applications
spaces
errors and, 89
extra, 8990
importing and, 271
special characters , 285, 335
Startup Variables functions, 200205
Status Variables settings, 210
STRCMP function, 159, 161
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_INDEX function, 156158
SUM function, 147148, 172
SWITCH control structure, 344345
system information, 210211
system requirements
Linux platform, 25
Windows platform, 89
System Variables settings, 210211