mysql help (sorry, a bit OT)
| From: | Gary | Date: | Tue, 16 Nov 2010 13:35:12 +0000 |
| Subject: | mysql help (sorry, a bit OT) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-309506@lists.php.net to get a copy of this message | ||
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
that changes the db contents) and would like to know that the sql I am
generating (in php - see! not so off-topic!) is correct.
What I don't want to do is run it for testing (live system *sigh*) and
find out it is correct (it will change the db), but... I have to test it
to check that the syntax (at least) *is* correct.