I have 500 independent insert queries. I put them in a transaction to run faster. I am runing queries with PHP.
What will happen if one of queries fails? Will the transaction be rolled back automaticaly or not?
Maybe this question has been asked before, but I cannot find an answer. If there is one, please share it with me.