Mysql Check

Mysql Check is used to check the existence of table in the database.

Mysql Check

Mysql Check

     

Mysql Check is used to check the existence of table in the database.

Understand with Example

The Tutorial illustrate an example from 'Mysql Check'.To understand this example we use CHECK TABLE keyword that show the existence of table in database.In case table is not existing in the database.The Message txt show you the status of table does not exist in database.

Query

CHECK TABLE new_table;

Result

+-----------------+-------+----------+---------------------------------------+
| Table           | Op    | Msg_type | Msg_text                              |
+-----------------+-------+----------+---------------------------------------+
| komal.new_table | check | error    | Table 'komal.new_table' doesn't exist |
+-----------------+-------+----------+---------------------------------------+