Wordpress - How to delete all records from or empty a custom database table?
I would just modify Q Studio example to:
global $wpdb;
$table = $wpdb->prefix . 'table_name';
$delete = $wpdb->query("TRUNCATE TABLE $table");
Thanks @s_ha_dum - Truncate does the job nicely:
// delete row ##
global $wpdb;
$delete = $wpdb->query("TRUNCATE TABLE `wp_table_name`");
2 years late, but maybe this will help someone in the future :)
The correct syntax for deleting rows from a MySQL table is:
DELETE FROM `wp_table_name`
WHERE 1 = 1;