Hi Sebastian, Thanks a lot for the info. Also i am automating the "LOAD DATA LOCAL INFILE" script. Is it possible for me to show any error or spool the error to the file.
My script take 4 input parameters a.login b.password. c.database d.hostname -e "load data local infile". How do spool any error messages into a file. regards anandkl On 5/21/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
Ananda Kumar schrieb: > When i do. > > show warnings > > It display only 64 rows, can i see all the 789 warning messages as show > above. http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html "The maximum number of error, warning, and note messages to store is controlled by the max_error_count system variable. By default, its value is 64. To change the number of messages you want stored, change the value of max_error_count." SHOW VARIABLES LIKE 'max_error_count'; SET max_error_count=1000; -- Sebastian Mendel www.sebastianmendel.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
