通达OA修复MYSQL的指定数据表

**通达OA邮件报错：

Table ‘.\td_oa\email_body‘ is marked as crashed and should be repaired

D:\MYOA\mysql5\bin\myisamchk.exe -c -r D:\MYOA\data5\TD_OA\email_body.MYI

以上这条指令是用于修复数据表的。
myisamchk 工具会帮助你恢复数据表的索引，也不用重新启动mysql，问题就解决了。**

//– MYOA数据库配置 —
$MYSQL_SERVER=”localhost:3336″;
$MYSQL_USER=”root”;
$MYSQL_DB=”TD_OA”;
$MYSQL_PASS=”myoa888″;

按照日期条件，表的插入数据指令
SELECT FROM email_body WHERE FROM_UNIXTIME(send_time)<‘2018-8-22 00:00:00‘ ORDER BY send_time DESC
INSERT INTO email_body SELECT FROM email_body20180726 WHERE FROM_UNIXTIME(send_time)<‘2018-7-26 00:00:00‘