COMMIT无法在phpmyadmin(MySQL)中工作 [英] COMMIT not working in phpmyadmin (MySQL)

问题描述

我有一个带有InnoDB类型的表tbl_setting的mysql数据库.它的自动提交设置为1.我在phpmyadmin中执行了以下查询.

I've a mysql database with table tbl_setting with InnoDB type. Its autocommit is set to 1. I executed following queries in phpmyadmin.

begin;
INSERT INTO tbl_setting (setting_name) VALUES ('test');
commit;

从phpmyadmin浏览时，它显示所需的结果；但是在Windows 8的命令模式下，查询SELECT * FROM tbl_setting不会显示我刚刚插入的行.我需要在命令模式下进行提交以获取所需的输出.数据库不应该自动更新吗?

While browsing from phpmyadmin, it is showing the desired result; But in command mode of Windows 8, with query SELECT * FROM tbl_setting it is not displaying the row I just inserted. I am needing to do commit in command mode to get the desired output. Shouldn't the database be updated automatically?

推荐答案

经过长期研究，我发现了问题所在.命令模式下的自动提交设置为0；否则，设置为0.因此，在执行SET @@AUTOCOMMIT = 1;查询后，问题得以解决.

After long research I found the problem. The autocommit in command mode was set 0; So, after executing SET @@AUTOCOMMIT = 1; query, the problem was solved.

这篇关于COMMIT无法在phpmyadmin(MySQL)中工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！