Dedecms empty Delete All documents new Document information ID starting from 1

Method one, log in to the background of the dream, find the system and system settings->sql command line tool

Run the following command, respectively:

Clear the data in the table and delete all articles:

TRUNCATE table ' dede_arctiny '; TRUNCATE table ' dede_archives '; TRUNCATE table ' dede_addonarticle ';

Newly published article ID starting from 1:

ALTER TABLE ' dede_arctype ' auto_increment = 1;

Then publish the article ID all starting from 1.

Method Two, delete the database information:

Delete from Dede_addonarticle;delete from Dede_addonimages;delete to Dede_archives;delete from Dede_arctiny;delete From Dede_co_htmls;delete to Dede_co_urls;delete from Dede_co_mediaurls;delete to Dede_tagindex;d elete from Dede_ Taglist;delete from Dede_keywords;

Run the above statement directly in the background, meaning to empty the article and the original collected records

TRUNCATE TABLE ' dede_archives;

Then run the above statement directly in the background

Use SQL to clear the table commands. The ID will start at 1.

Dede article deleted after ID set method starting from 1

You only need to execute three SQL statements:

A lot of people just set the primary table Dede_archives ID to 1, so it's not working. It is important that both the micro-table dede_arctiny and the additional table dede_addonarticle be executed together so that the ID can start at 1.

ALTER TABLE ' dede_archives ' auto_increment =1=1= 1;

Dedecms Empty Delete all documents new Document information ID starting from 1