If you want to delete all the rows from a table, you can use the DELETE clause without the WHERE clause.
Be very careful with this method since you will be deleting all the rows in a table and once done, they can't be retrieved.
You can execute the following code to delete all the rows from the allstarfull table in the yourschema database:
USE yourschema;
DELETE FROM allstarfull;
The previous code deletes everything from the allstarfull table.