You could pre-pend "EXPLAIN" and see if it generates an error.
--
Nick Arnett
Phone/fax: (408) 904-7198
narnett@stripped
> -----Original Message-----
> From: Jerry [mailto:jerry@stripped]
> Sent: Friday, April 04, 2003 5:46 AM
> To: mysql@stripped
> 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/mysql?unsub=1
