The SQL delete statement requires the table name and optional conditions.
DELETE from table_name [WHERE conditions];
NOTE: If you don’t specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED!!!
One of the Multimedia specialists ‘Hasan Rajabi’ (employee id 10) leaves the company. We’ll delete his entry.
DELETE from employee_data WHERE emp_id = 10; Query OK, 1 row affected (0.00 sec)
Gmail displays "Lockdown in Sector 4" error message if it suspects abnormal usage at an account. The account can be put offline upto to 24 hours. This is a great security measure put in place by the Google email service. [more...]