$wpdb->query('START TRANSACTION');
$wpdb->insert($wpdb->prefix.'test',
    array(
        'name'=>'零五网',
        'url' =>'https://www.02405.com',
        'createtime' => current_time('mysql')
    )
);
if ($wpdb->last_error) {
    $wpdb->query('ROLLBACK');
} else {
    $wpdb->query('COMMIT');
}

修改Mysql引擎，因为InnoDB才支持事务

SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=InnoDB;' )
FROM information_schema.tables
WHERE table_schema = 'wplearn_cc'
LIMIT 0 , 10000;