How to use sql statement to delete all article information in empire cms7.5 and let the ID start from 1

Empire uses SQL statements to delete all information, article content, columns, tags, and member groups in Empire CMS. If you are a new purchaser of a template and the data in the template is not what you want, then you can use the following SQL statement

TRUNCATE `[!db.pre!]ecms_news`;
TRUNCATE `[!db.pre!]ecms_news_check`;
TRUNCATE `[!db.pre!]ecms_news_check_data`;
TRUNCATE `[!db.pre!]ecms_news_data_1`;
TRUNCATE `[!db.pre!]ecms_news_index`;
TRUNCATE `[!db.pre!]enewsclass`;
TRUNCATE `[!db.pre!]enewsclassadd`;
TRUNCATE `[!db.pre!]enewstags`;
TRUNCATE `[!db.pre!]enewstagsclass`;
TRUNCATE `[!db.pre!]enewstagsdata`;
TRUNCATE `[!db.pre!]enewsfile_1`;
TRUNCATE `[!db.pre!]enewsmember`;
TRUNCATE `[!db.pre!]enewsmemberadd`;

Attention! Be sure to make a complete copy and then execute it in the background. This SQL is only for the news data table.