MariaDB [test]> create table t1 (i int);

Query OK, 0 rows affected (1.53 sec)

MariaDB [test]> insert into t1 values (1),(2);

Query OK, 2 rows affected (0.10 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> analyze delete from t1;

+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------------------+

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | r_rows | filtered | r_filtered | Extra             |

+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------------------+

|    1 | SIMPLE      | NULL  | NULL | NULL          | NULL | NULL    | NULL |    2 |   NULL |     NULL |       NULL | Deleting all rows |

+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------------------+

1 row in set (0.00 sec)

MariaDB [test]> select * from t1;

+------+

| i    |

+------+

|    1 |

|    2 |

+------+

2 rows in set (0.00 sec)

create table t1 (i int);

insert into t1 values (1),(2);

analyze delete from t1;

select * from t1;

drop table t1;