> -----Original Message-----
> From: Thomas von Elling Skifter Eibner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 7:27 AM
> To: Mark Riehl
> >
> > The New Riders MySQL book has the following statements:
> > SELECT COUNT(*) FROM table_name
> > SELECT * FROM table_name WHERE 1=0
> >
> > Each statement will succeed if the table exists.
> >
> > Any other way (other than calling $dbh->tables() and
> looping through the
> > results?
>
> SELECT 1 FROM table_name (just another variant of yours).
>
select * from table_name
$DBI::state will be 'S0002' if the reason for the error retuned is that the
table does not exist.
Neil
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
