Re: Debugging batch sql statements

2007-10-05 Thread Arun
I just want to see the original insert statement which failed, so that I can do a search on it. Is there any option for seeing the insert statement that gets executed and the error line next to next.? On 10/5/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > Arun wrote: > > I have a large batch of

Re: Debugging batch sql statements

2007-10-05 Thread Jørn Dahl-Stamnes
On Friday 05 October 2007 16:50, Arun wrote: > Baron, > I am sourcing it. I do not know if that is the best way though.. I am > running the insert statement from a mysql prompt in a linux/windows > machine. > My script has a single build script which sources other scripts. > build.sql > == > s

Re: Debugging batch sql statements

2007-10-05 Thread Arun
Baron, I am sourcing it. I do not know if that is the best way though.. I am running the insert statement from a mysql prompt in a linux/windows machine. My script has a single build script which sources other scripts. build.sql == source ./ddl/useraccount/useraccountddl.sql source ./mobchanne

Re: Debugging batch sql statements

2007-10-05 Thread Baron Schwartz
Arun wrote: I have a large batch of insert sql statements, of which some of them are failing. I want to know which one is failing exactly. Is there anyway I can debug it and which statement went wrong. I have only 4 or 5 out of 200 statements that are failing. It depends on how you're running t

Debugging batch sql statements

2007-10-05 Thread Arun
I have a large batch of insert sql statements, of which some of them are failing. I want to know which one is failing exactly. Is there anyway I can debug it and which statement went wrong. I have only 4 or 5 out of 200 statements that are failing. -- Thanks Arun George