Best way to delete all records on an ESS Table for MySQL

[Fred_S]

Hi,

I have an ESS connection into a MySQL database. I need to delete all of the data in the MySQL database and then add new records via the server (from the same FileMaker file). Im wondering, is there a best/fast way to delete all of the records in the MySQL table from FileMaker? On MySQL/PHPmyAdmin I would simply run a TRUNCATE table_name, but Im not sure if that's possible or recommended. Thanks in advance.