D7 - Batch delete webform submissions

Forums: 

If your receive flood of emails from webform submissions because the webform accidentally left open to annonymous and you would like to clean out submission, please

let us know immediately so we can delete the submission throush SQL commands. Webform submissions currently is not possible to delete using View Bulk Operations module.

 

Web form submissions can be delete with the following command (where :nid is the node ID of the webform and :sid is the last valid submission, the 'not in (....)' can be used if there are some valid submissions found within those automated submission)

delete from webform_submissions where nid = :nid and sid > :sid;
delete from webform_submitted_data where nid = :nid and sid > :sid;