[PhamHoang]

I want a simple command like /deleteallaccounts in MYSQL
Even that account does not work (( connected to server))
Except I was not deleted account
Help me...

[GTLS]

Use

PHP Code:

drop table accounts; 


to delete your accounts table. so all accounts will be deleted.

Dont forget to add,

PHP Code:

 CREATE TABLE IF NOT EXIST(......) // insert your Table Structure here 


in OnGameModeInit();

[GoldenLion]

Quote:

Originally Posted by GTLS Use PHP Code: drop table accounts;  to delete your accounts table. so all accounts will be deleted. Dont forget to add, PHP Code:  CREATE TABLE IF NOT EXIST(......) // insert your Table Structure here  in OnGameModeInit();

Code:

DELETE FROM accounts WHERE 1

you can add something like

Code:

AND Name != 'yourname'

so it won't delete your account.

[DRIFT_HUNTER]

pawn Code:

TRUNCATE tableName;

[ISmokezU]

Quote:

Originally Posted by DRIFT_HUNTER pawn Code: TRUNCATE tableName;

Keeping in mind if the table(s) Has a relationship, Truncate wouldn't work.

[PhamHoang]

i'll try,thanks