SQL DELETE command

DELETE command is used to delete row from table. The structure is the following: DELETE FROM <tableName> WHERE <condition>; Warning: if we don't put condition, then it will simply delete all rows in the table. For example, say we have: MariaDB [firstDB]> SELECT * FROM employee; +------------+-----------+-----------------+--------+ | first_name | last_name | employee_number | salary … Continue reading SQL DELETE command

Advertisements