Home / MySQL / mysql beginner tutorial – Deleting entries from tables
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)
How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]
Logitech was the first company to sell the modern computer mouse. The device with an optical encoder, two buttons and a single ball was created by Jean-Daniel Nicoud and André; Guignard of the Ecole Polytechnique Federale de Lausanne in Switzerland. Their mouse was a major improvement over the one created by Douglas Engelbart, the original creator of the mouse. Logitech's computer mouse was originally manufactured by Dubois Depraz SA, another Swiss company. From 1985 to 2008, the company sold a billion of these devices! [more...]
We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy
IMPORTANT Have a question / problem?