首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >Server version: 5.5.60-MariaDB autocommit 参数修改不成功?

Server version: 5.5.60-MariaDB autocommit 参数修改不成功?

提问于 2019-12-06 14:48:57
回答 0关注 0查看 399

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)]>

回答

和开发者交流更多问题细节吧,去 写回答
相关文章

相似问题

相关问答用户
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档