You could pre-pend "EXPLAIN" and see if it generates an error. -- Nick Arnett Phone/fax: (408) 904-7198 [EMAIL PROTECTED]
> -----Original Message----- > From: Jerry [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2003 5:46 AM > To: [EMAIL PROTECTED] > Subject: Pre parsing > > > Hi, > > Anyone know of a way of pre parsing a *.sql file to make sure that it is > syntactically correct , opposed to having to up load a file and when it > breaks loosing everything after the line with an error on it. > > Either that or a way of telling it to carry on after finding an error. > > i.e. using > > mysql -u user -ppassword my_dB < some_file.sql > > With the "Just do it" flag ? > > > Cheers > Jerry > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]