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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
