极客教程如何检查MySQL表是否存在？
接下来，让我们看一些检查MySQL表是否存在的方法。
阅读更多：MySQL 教程
使用SHOW命令
SHOW命令会显示所有表。
SHOW tables;
以下是输出结果。
+--------------------------+
| Tables_in_business |
+--------------------------+
| addcheckconstraintdemo |
| addcolumntable |
| addconstraintdemo |
| alphademo |
| autoincrement |
| autoincrementtable |
| backticksymbol |
| bookindexes |
| chardemo |
| checkdemo |
| clonestudent |
| columnexistdemo |
| columnvaluenulldemo |
| commaseperatedemo |
| dateadddemo |
| deletedemo |
| deleterecord |
| demo |
| demo1 |
| demoascii |
| demoauto |
| demobcrypt |
| demoemptyandnull |
| demoint |
| demoonreplace |
| demoschema |
| demowhere |
| distinctdemo |
| duplicatebookindexes |
| duplicatefound |
| employeetable |
| escapedeom |
| existsrowdemo |
| findandreplacedemo |
| firsttable |
| foreigntable |
| foreigntabledemo |
| functiontriggersdemo |
| groupdemo |
| groupdemo1 |
| ifelsedemo |
| imagedemo |
| incasesensdemo |
| indexingdemo |
| int1demo |
| intdemo |
| latandlangdemo |
| limitoffsetdemo |
| milliseconddemo |
| modifycolumnnamedemo |
| modifydatatype |
| moneydemo |
| moviecollection |
| multipleindexdemo |
| multiplerecordwithvalues |
| mytable |
| mytable1 |
| nextpreviousdemo |
| nonasciidemo |
| nthrecorddemo |
| nulldemo |
| nullwithselect |
| numbercolumndemo |
| ondemo |
| pasthistory |
| presenthistory |
| primarytable |
| primarytable1 |
| primarytabledemo |
| qutesdemo |
| rowcountdemo |
| rownumberdemo |
| rowstranspose |
| rowstransposedemo |
| secondtable |
| sequencedemo |
| smallintdemo |
| sortingvarchardemo |
| spacecolumn |
| student |
| tbldemotrail |
| tblf |
| tblfirst |
| tblfunctiontrigger |
| tblifdemo |
| tblp |
| tblselectdemo |
| tblstudent |
| tbluni |
| tblupdatelimit |
| textdemo |
| texturl |
| timestampdemo |
| trailingandleadingdemo |
| transcationdemo |
| triggedemo |
| trigger1 |
| trigger2demo |
| unsigneddemo |
| updtable |
| usernameandpassworddemo |
| varchardemo |
| varchardemo1 |
| varchardemo2 |
| varcharurl |
| whereconditon |
| xmldemo |
+--------------------------+
107 rows in set (0.15 sec)
使用LIKE命令显示单个表
以下是该命令的语法。
SHOW TABLESLIKE 'yourTableName';
现在我们将以上语法实现到以下查询中。
mysql> SHOW TABLES LIKE 'tblstudent';
以下是输出结果。
+---------------------------------+
| Tables_in_business (tblstudent) |
+---------------------------------+
| tblstudent |
+---------------------------------+
1 row in set (0.00 sec)