Question

syntax to delete row of a table without dropping the table in mysql​

Answer 1

Answer:

delete from <tabel name> where <condition>;

Explanation:

i hope it really helps you

please make me brainliest

Answer 2

steps to delete row of a table without dropping the table in mysql-

• First, specify the table from which you delete data.
• Second, use a condition to specify which rows to delete in the WHERE clause. The DELETE statement will delete rows that match the condition,

Notice that the WHERE clause is optional. If you omit the WHERE clause, the DELETE statement will delete all rows in the table.

Besides deleting data from a table, the DELETE statement returns the number of deleted rows.