Server version: 5.5.60-MariaDB MariaDB Server
MariaDB [(none)]> SET autocommit OFF;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OFF' at line 1
MariaDB [(none)]> set autocommit OFF;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OFF' at line 1
MariaDB [(none)]> set global autocommit OFF;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OFF' at line 1
MariaDB [(none)]> set global autocommit OFF;
MariaDB [(none)]> SHOW VARIABLES LIKE "%AUTO%";
+-----------------------------+-------+
| Variable_name | Value |
+-----------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| innodb_autoextend_increment | 8 |
| innodb_autoinc_lock_mode | 1 |
| innodb_stats_auto_update | 1 |
| sql_auto_is_null | OFF |
+-----------------------------+-------+
8 rows in set (0.00 sec)
MariaDB [(none)]>
相似问题