[q8mazad]

thanks for the quick reply to me

Actually I did it before
by created a file file.txt contains the below records

delete from post where userid=991;
delete from post where userid=992;
delete from post where userid=993;
delete from post where userid=994;
delete from subscribethread where userid=991;
delete from subscribethread where userid=992;
delete from subscribethread where userid=993;
delete from subscribethread where userid=994;
delete from thread where postusername ='XXA';
delete from thread where postusername ='XXB';
delete from thread where postusername ='XXC';

and run it

[root@vmi5 ~]# mysql vbdb < file.txt

is working , but I facing issue that i'm getting empty posts for the rest of the members.

I want a complete and correct way to completely delete the user from all fields,