Re: Do sourced queries automatically commit?

2007-03-19 Thread Kevin Chen
João Cândido de Souza Neto [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Could you try to put the start transaction into your .sql file. Ok, I tried that -- same result. I even tried including the rollback in the .sql file as well, but the changes are still committed afterwards. The

Re: Do sourced queries automatically commit?

2007-03-19 Thread Jo�o C�ndido de Souza Neto
You can try to do a set autocommit=0; Kevin Chen [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] João Cândido de Souza Neto [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Could you try to put the start transaction into your .sql file. Ok, I tried that -- same

Do sourced queries automatically commit?

2007-03-18 Thread Kevin Chen
Greetings all, I am trying to track down the cause of some issues I'm having. I am doing this from the mysql prompt: start transaction; source c:/queries.sql; rollback; When I examine the db though, it appears that the changes from the sourced queries have been committed. -- MySQL General