TLingC's Zone
TLingC's Zone

MySQL
文章归档

MySQL Table doesn't exist in engine 解决方法

数据表设置了外键,在phpMyAdmin中显示该表使用中,点击访问表时提示Table doesn't exist in engine。 mysql日志显示: 2019-08-24 14:32:25 616 [Warning] InnoDB: Load table 'xxx' failed, the table has missing foreign key indexes. Turn off 'foreign_key_c…

   210   2019-08-24   阅读更多

利用PHP把MySQL数据库内所有表编码转换为utf8mb4

<?php $mysql = mysql_connect(MYSQL_HOST,MYSQL_USERNAME,MYSQL_PASSWORD); if (!$mysql) echo "Failed to connect mysql!"; mysql_select_db(MYSQL_DBNAME,$mysql); $result = mysql_query("SHOW TABLE STATUS"); while($row = mysql_fetch_r…

   80   2018-02-22   阅读更多
标签
功能