...
另一個方式取代 truncate
mysql> create table NEW_OVM_STATISTIC like OVM_STATISTIC; mysql> rename table OVM_STATISTIC to OLD_OVM_STATISTIC, NEW_OVM_STATISTIC to OVM_STATISTIC; mysql> drop table OLD_OVM_STATISTIC;
...
...
...
另一個方式取代 truncate
mysql> create table NEW_OVM_STATISTIC like OVM_STATISTIC; mysql> rename table OVM_STATISTIC to OLD_OVM_STATISTIC, NEW_OVM_STATISTIC to OVM_STATISTIC; mysql> drop table OLD_OVM_STATISTIC;
...