pre-testing a query

[sfullman]

Hi All,

Is there any way to "try" and SQL query first and see if it is a problem and get back the problem, without actually running the query? Sort of like going to the grocery store and asking the checker just to scan an item for a price, I don't want to buy it yet :-)

for example
TRY INSERT INTO SET Name='Sam', LastName='Fullman'

giving back something like "You forgot a table name!"

Thanks,
Sam

[nemonoman]

Not if using MySQL, which would throw an ambiguous error message

$result=mysql_query("INSERT INTO SET Name='Sam', LastName='Fullman' ");
echo mysql_error($result);

would echo something like:

"You have an error in your SQL near 'SET Name..."

Not very helpful.