Learning MySQL, 2nd Edition

Index

Symbols

• \ (backslash), Loading Data from Comma-Delimited Files, Structure of the Option File
• ` (backtick), Creating and Using Databases, Basics
• = (equal), WHERE basics, WHERE basics
• / (forward slash), Loading Data from Comma-Delimited Files
• > (greater than), WHERE basics
• >= (greater than or equal), WHERE basics
• < (less than), WHERE basics
• <= (less than or equal), WHERE basics
• # (Linux comment), Become root in Linux, Structure of the Option File
• != (not equal), WHERE basics
• <> (not equal), WHERE basics
• # (option file comment), Structure of the Option File
• # (root user), Become root in Linux
• ~ (tilde), Scope of Options
• _ (underscore for names), Basics
• % (wildcard), WHERE basics
  • role hostnames, Roles
  • user hostnames, Creating and Using New Users, GRANT
  • usernames, GRANT
• _ (wildcard for single character), WHERE basics
• 0 as false, Integer types
• 1 as true, Integer types
• 32-bit versus 64-bit installations, Installation Choices and Platforms, Installing MySQL on Windows 10

A

• access control list (ACL) for network, Understanding Users and Privileges
• ACID transactions, Transactions and Locking
  • innodb_flush_log_at_trx_commit, The innodb_flush_log_at_trx_commit parameter
  • storage engines, Alternative Storage Engines
• aggregating data
  • about, Aggregating Data
  • aggregate functions
    • AVG(), Aggregate functions
    • COUNT(), Joining Two Tables, The GROUP BY Clause
    • MAX(), Aggregate functions
    • MIN(), Aggregate functions
    • reference online, Aggregate functions
    • STD(), STDDEV(), Aggregate functions
    • SUM(), Aggregate functions
  • DISTINCT clause, The DISTINCT ...