Subsonic Forum

It would be nice if there was a Delete All Players button. I like to clear out all the Players people have left and it would be nice if I didn't have to click the button 30-40 times when I do it.

View all players (http://localhost/db.view):

Code: Select all

select * from PLAYER

Remove players with username 'guest' (change 'guest' with other if necessary):

Code: Select all

delete from PLAYER where USERNAME='guest'

Remove all players:

Code: Select all

delete from PLAYER

SQL Tutorial: http://www.tizag.com/sqlTutorial/
MySQL Tutorial: http://www.tizag.com/mysqlTutorial/

Very very cool. I did not realize that there was an exposed DB query screen. Thanks for sharing.

Glenn