You could pre-pend "EXPLAIN" and see if it generates an error.
Phone/fax: (408) 904-7198
> -----Original Message-----
> From: Jerry [mailto:jerry@stripped]
> Sent: Friday, April 04, 2003 5:46 AM
> To: mysql@stripped
> Subject: Pre parsing
> 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 ?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: