COMMIT not working in phpmyadmin (MySQL)

Question

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;

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?

Pradip Kharbuja · Accepted Answer · 2013-03-11 17:10:03Z

2

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.

answered Mar 11, 2013 at 17:10

Pradip Kharbuja

3,5686 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

COMMIT not working in phpmyadmin (MySQL)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related