mariadb root@localhost:dyw> select * from tbl; +----+---------+--------+-----------------+ | id | title | author | submission_date | +----+---------+--------+-----------------+ | 1 | c++ | peter | 2020-01-28 | | 2 | MariaDB | dywang | 2020-01-01 | | 3 | Linux | linux | 2020-01-11 | +----+---------+--------+-----------------+ 3 rows in set Time: 0.032s
mariadb root@localhost:dyw> delete from tbl where id=3; You're about to run a destructive command. Do you want to proceed? (y/n): y Your call! Query OK, 1 row affected Time: 0.008s
mariadb root@localhost:dyw> select * from tbl; +----+---------+--------+-----------------+ | id | title | author | submission_date | +----+---------+--------+-----------------+ | 1 | c++ | peter | 2020-01-28 | | 2 | MariaDB | dywang | 2020-01-01 | +----+---------+--------+-----------------+ 2 rows in set Time: 0.030s