¿SQL Query to Delete all accounts / characters?

[mfurius2006]

Hello, I want to delete all my accounts and PJs, since I have over 1500 accounts, and delete them one by one I think it would very stupid (?) If anyone can provide me with a query to delete all appreciate it


thanks

[MentaL]

[zyghybr]

You dont need a query, you can enter on DB> MuOnline>Table > Character,DB> MuOnline>Table > Account, DB> MuOnline>Table > MEMB_INFO , open table select all cells and delete

[_Gabriel_]

Wouldn't be easier to restore an empty database? You need to delete data from all the tables. Yet, you can use:

DELETE FROM <table_name>

[zyghybr]

If he delete table ,all data in "design table" will be lost...you can emply a tabel no delete it..

[_Gabriel_]

It deletes the rows/tuples, not the relation schema.

[mfurius2006]

Hi, thanks for the comments.


What I want is to use the same database without restoring again, but delete the all accounts and PJs, it is possible?