Invalid update SQL in DataGrip

Question

I wrote a MySQL update SQL on my DataGrip to update the wrong data:

update common_express_track set step = 135 where express_id in (33, 235, 237) and business_source = 0 and step = 0 and content = 'Out For Delivery' order by content;

I executed it, the console showed that "61 rows affected in 7s 530ms" and then I executed an another query statement to make sure the data has been modified.

select * from common_express_track where express_id in (33, 235, 237) and business_source = 0 and step = 0 and content = 'Out For Delivery' order by content;

Then the console shows that "0 rows retrieved in 3s 751ms".

But when I restart the DataGrip and execute the query statement again, I got 61 rows, that means the update statement didn't work, I don't know why, is it because the cache or something?

How to solve this problem?

Answer 1

When you execute queries you should use Autocommit

Then by clicking on table in database view you will see refresh

Try use Autocommit with your query and refresh when you browse data. It should help.