Hi Baron, I cannot do this, becuase the file would be given by engineers and to be applied on mysql and i need to inform them about any error after i apply them in mysql db.
regards anandkl On 5/21/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi, I see now -- you want to see which commands were executed from the file you sourced. As far as I know you cannot do this. You could add some debugging statements in the file, like SELECT 'about to drop the table'; Then in the output you will see this, and it may give you a hint as to where the error happened. Baron Ananda Kumar wrote: > Hi Baron, > This will give only the results of the command. It does not include sql > statement. > I need the sql statement to know which sql errored out. > > Database changed > +----------+ > | count(*) | > +----------+ > | 5 | > +----------+ > 1 row in set (0.00 sec) > > > > On 5/21/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> Ananda Kumar wrote: >> > Hi All, >> > I am executing a script from mysql prompt as below >> > >> > mysql > source ddl.txt >> > >> > I want to spool the out put of the above command to a file along with >> the >> > sql statments. Can you please let me know what parameter should i set >> for >> > the this. >> >> Use the 'tee' command in the mysql client. Press ? in the client and it >> will give you >> instructions. >> >> Baron >> > -- Baron Schwartz http://www.xaprb.com/