var query = connection.query('DELETE FROM book WHERE collection_id IN ?', [collectionId], function(error, result) { if (error) { console.log('An error has occurred: %s', error); return; } console.log('%s records have been successfully deleted', result.affectedRows); });