All, What's the easiest way to check and see if a table already exists in a database? I'm running MySQL on a Win2k box. 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? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]
- Re: Easiest way to tell if a table alread... Mark Riehl
- Re: Easiest way to tell if a table a... Thomas von Elling Skifter Eibner
- Re: Easiest way to tell if a table a... Mark Thornber
- RE: Easiest way to tell if a table a... Neil Lunn
- Re: Easiest way to tell if a tab... Mike Schienle
- RE: Easiest way to tell if a... Sterin, Ilya
- RE: Easiest way to tell ... PD Miller
- RE: Easiest way to tell if a table a... Neil Lunn
- Re: Easiest way to tell if a tab... Mike Schienle
- RE: Easiest way to tell if a table a... Neil Lunn
- Re: Easiest way to tell if a tab... Michael A. Chase