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:
sql,  mysql,  c,  database,  table,  data,  sed,  tab,  check,  to,  base,  e,  use,  ce,  in,  as,  m,  ase,  s,  at,  my,  k,  is,  xi,  s,  s,  th,  st,  ab,  abl,  exi,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql Check  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):