How to delete members in dedecms

Dedecms method to delete members: 1. Back up the database; 2. Open the dede backend system, and then use the SQL statement "delete from dede_member where not mid="1"" to delete registered members in batches.

The operating environment of this tutorial: Windows 10 system, DedeCMS version 5.10, Dell G3 computer.

dedecmsHow to delete members?

dedecms method of deleting junk members

The specific implementation method is as follows:

Some webmasters must have a headache about members, and some people are idle and bored on the website A lot of members have been registered on the website and a lot of spam information has been posted.

My website is often registered by some registration software and a large number of illegal users. I solved the problem by using dedecms to batch delete members' SQL statements. Now I have a solution here, so I won’t say any more nonsense and go straight to the topic.

1. The database must be backed up before operation.

As shown in the figure below:

2. This method is only applicable to the administrator's website.

dedecms uses SQL to batch delete registered members. Member registration information is mainly in the dede_member table. System/SQL command line tool, query how many members there are in the table select * from dede_member

3. Query results: Run the

code as follows:

SQL：select * from dede_member

There are 598 records in total, and the maximum return is 100.

Delete method:

Open dede background system---->sql command line tool

The code is as follows:

delete from dede_member where not mid="1"

(mid: 1 is myself, so I won’t delete it) as Picture:

One SQL statement was successfully executed. Look again, there are no more registered users. This is the end.

《Recommended Learning: dedecms Tutorial》

The above is the detailed content of How to delete members in dedecms. For more information, please follow other related articles on the PHP Chinese website!