Solved How to delete all players?

[naod123456]

How do i delete all players form my database but i don´t whanan delete the the accounts I use xampp phpmyadmin.

 

[Alpha]

Run this query:

TRUNCATE TABLE players;

 

[naod123456]

Run this query:

TRUNCATE TABLE players;

dosn´t work getting this error

[B]SQL-fråga:[/B]


TRUNCATE TABLE players



[B]MySQL sa: [/B][URL='http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Ferror-messages-server.html&token=8097173127ddece8826574cd0e1d3f19'][IMG]http://localhost/phpmyadmin/themes/dot.gif[/IMG][/URL]

#1701 - Cannot truncate a table referenced in a foreign key constraint (`noobwar`.`account_viplist`, CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `noobwar`.`players` (`id`))