Home Sql Mysql-example Mysql Check



Mysql Check
Posted on: January 17, 2009 at 12:00 AM
Mysql Check is used to check the existence of table in the database.

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 |
+-----------------+-------+----------+---------------------------------------+

Related Tags for Mysql Check:
sqlmysqlcdatabasetabledatasedtabchecktobaseeuseceinasmasesatmykisxissthstabablexio


More Tutorials from this section

Ask Questions?    Discuss: Mysql Check  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.