Mysql> CREATE TABLE Test3(ID INT, Name VARCHAR(255)) įollowing query verifies all these tables and displays the result − Mysql> CREATE TABLE Test2(ID INT, Name VARCHAR(255)) Mysql> CREATE TABLE Test1(ID INT, Name VARCHAR(255)) ExampleĪssume we have created three new tables as shown below − You can also verify the status of multiple tables at once using the CHECK TABLE Statement. Mysql> insert into sales values(5, 'Headset', 'Jalaja', DATE(''), TIME('11:08:59'), 6000, 'Goa') įollowing table verifies the status of the above table − Now, we will insert 5 records in Sales table using INSERT statements − Īssume we have created a table named sales as shown below − Syntaxįollowing is the syntax of the MySQL CHECK TABLE Statement −ĬHECK TABLE tbl_name. The MySQL CHECK TABLE Statement is used to check the integrity of database tables, if there’re are any errors in the specified table this statement lists them out.
Sometimes specific tables will be crushed.
These situations could make the database operate incorrectly and in the worst case, it can be crashed. In case something wrong happens to the database server like if the server was shutdown unexpectedly or, an error occurred while writing data to the hard disk, etc.
0 kommentar(er)
