Appendix C. System Variables
This appendix contains an alphabetical listing of the system variables that relate to the functioning of SQL statements; see Sections 4.14 and 5.7 for descriptions of system variables and how to change the values of system variables. For all system variables, we give the allowed values and the default value, describe the type of the system variable, and give a short description.
Autocommit
Type: Session
Values: 0 (OFF) or 1 (ON)
Default value: 0 (OFF)
Description: If this system variable is turned on (value 1), a COMMIT statement is executed after each SQL statement. Assigning the value 0 to this variable turns off this automatic committing; see Section 37.2.
Auto_increment_increment
Type: Global, session
Values: ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
