how to delete this on sql?

[PewN]

how can i delete the pvpladder on sql query?

cuz i got a problem here. help

DELETE FROM `pvpladder` WHERE `char_id`,`name`,`streaks`,`kills`,`deaths`,`streaktime`

[JoWei]

Not sure what you want but if you want to delete table entirely then it should be

DROP TABLE `pvpladder`

or if you want to only empty the table then it should be

 TRUNCATE TABLE `pvpladder` 

That code you provide only delete an entry and is wrongly formatted as it suppose to have conditional entry after WHERE

which should be for example

DELETE FROM `pvpladder` WHERE `char_id` = 123456

which will delete all entries from `pvpladder` with `char_id` equal to 123456.

[Elijah23]

It depends on how you are saving the values in your ladder..

if the values saves when the player logouts, you need to do the deleting when all players are not online.

You can use the @maintenance command if you have it then do a drop table and create table again..