michaellunsford Posted May 10, 2006 Share Posted May 10, 2006 ran through the refman without much luck -- I just don't know what to search for. I found something in the PHP manual as a starting point "SQL SHOW TABLES" but I don't want to parse through a long list of table names -- just see if a very specific table name exists. Any ideas?Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/ Share on other sites More sharing options...
ryanlwh Posted May 10, 2006 Share Posted May 10, 2006 try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]SHOW TABLES [color=orange]LIKE[/color] [color=red]'table_name'[/color] [!--sql2--][/div][!--sql3--]If table_name doesn't exist, it will return empty set. Quote Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/#findComment-35047 Share on other sites More sharing options...
michaellunsford Posted May 15, 2006 Author Share Posted May 15, 2006 Thanks. got it working. Quote Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/#findComment-35941 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.