MySQL: Essential Skills

L

language settings, 195, 204

LEFT function, 163164

LEFT JOIN function, 185187, 190

LENGTH function, 158

Lerdorf, Rasmus, 330

LIKE function, 159160

LIKE reserved word, 128

LIMIT option, 98, 105, 121123, 130

Line Terminator, 80

link parameter, 246248

linking MySQL data in Access, 273275

Linux Line Terminator, 80

Linux systems, 3233. See also operating systems

cost of, 8

downloading MySQL files, 2526

evaluating, 58

free/ open source software and, 8

help listing, 3233

installing MySQL on, 2528

installing MySQLCC on, 239240

Microsoft technologies and, 8

MySQL Administrator, 221222

MySQL- related downloads for, 3536

naming considerations, 54

passwords, 27, 279

resetting root password on, 279

root user , 27, 279

system requirements, 25

using command prompt in, 3235

localization options, 204

locked items, 60

log files

binary update log, 293, 302

error, 212

query, 212

security of, 280

server logs, 211212

LOG function, 151

log options, 203

LOG10 function, 151

logarithms, 150152

logic coding, 258259

logical operators, 339

LONGBLOB data type, 47

LONGTEXT data type, 47

LOWER function, 162

LOW_PRIORITY keyword, 109

LPAD function, 161162

LTRIM function, 162163