The MariaDB DELETE statement is used to delete one or more records from the table in the database. It can be used to delete records from the table as well the whole table if you use it without WHERE condition.

Syntax:

DELETE FROM table

[WHERE conditions]

[ORDER BY expression [ ASC | DESC ]]

[LIMIT number_rows];