清空直接:
- TRUNCATE TABLE `actorbinarydata`;
TRUNCATE TABLE `actorguild`;
TRUNCATE TABLE `actorlogin`;
TRUNCATE TABLE `actormsg`;
TRUNCATE TABLE `actoroldname`;
TRUNCATE TABLE `actors`;
TRUNCATE TABLE `actorvariable`;
TRUNCATE TABLE `auction`;
TRUNCATE TABLE `chatmonitoring`;
TRUNCATE TABLE `feecallback`;
TRUNCATE TABLE `filternames`;
TRUNCATE TABLE `friends`;
TRUNCATE TABLE `globalmails`;
TRUNCATE TABLE `globaluser`;
TRUNCATE TABLE `gmcmd`;
TRUNCATE TABLE `guildchat`;
TRUNCATE TABLE `guildlist`;
TRUNCATE TABLE `guildlog`;
TRUNCATE TABLE `guildstorelog`;
TRUNCATE TABLE `items`;
TRUNCATE TABLE `mails`;
TRUNCATE TABLE `offlinemails`;
TRUNCATE TABLE `roles`;
TRUNCATE TABLE `servercmd`;
TRUNCATE TABLE `sysvar`;
TRUNCATE TABLE `txapimsg`;
复制代码或者。