Mysql Data Sheet in PHPMYADMIN

xiaoxiao2021-03-06  90

It is inevitable that the database is wrong, and it will definitely need to fix it.

PHPMYADMIN is a very good mysql management tool, and he has a fix function for a table in a database. But when this table has not been opened, it will not be seen at all (actually a web connection).

In fact, just find a normal database normal data table, we look at this repair the connection: http: //localhost/phpmyadmin/sql.php lang = zh-gb2312 & server = 1 & db = mydb & table = mytable & goto = tbl_properties_operations.php & back = tbl_properties_operations?. PHP & SQL_QUERY = Repair Table % 60myTable% 60

Change the MyDB to your actual database, replace myTable with your actual data sheet, copy to the address bar, and enter. See if it is fixed? Ha ha.

This method can repair 80% MySQL data sheet. But it may sometimes be inappropriate.

With the development of the MySQL database system, the support of the transaction will greatly reduce the condition of data sheets being destroyed.

转载请注明原文地址:https://www.9cbs.com/read-122857.html

New Post(0)