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]