MySQL commit trigger done

Question

I have MySQL database where I'm loading big files which insert more than 190 000 rows. I'm using python script which is doing some stuff and then load data from csv file into mysql execute query and commit.

My question is if I'm sending such a big file, is database ready after commit command or how to trigger when all datas are inserted in database?

Michael - sqlbot · Accepted Answer · 2017-10-14 13:53:51Z

1

The COMMIT does not actually return until the data has been... committed... so, yes, once you have committed any transaction, the work from that transaction is entirely done, as far as your application is concerned.

answered Oct 14, 2017 at 13:53

Michael - sqlbot

181k28 gold badges388 silver badges458 bronze badges

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

Collectives™ on Stack Overflow

MySQL commit trigger done

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related