Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Delete Multiple Rows from a Table
How To Delete Multiple Rows from a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table:
mysql> SELECT id, url, notes, counts FROM fyi_links WHERE id > 300; +-----+-------------------+-------+--------+ | id | url | notes | counts | +-----+-------------------+-------+--------+ | 801 | moc.retneciyf.ved | Wrong | 1602 | | 802 | moc.retneciyf.abd | Wrong | 1604 | | 803 | moc.retneciyf.aqs | Wrong | 1606 | | 810 | | Wrong | 1620 | | 700 | moc.retneciyf.www | Wrong | 1400 | +-----+-------------------+-------+--------+ 5 rows in set (0.00 sec) mysql> DELETE FROM fyi_links WHERE id > 300; Query OK, 5 rows affected (0.00 sec) mysql> SELECT id, url, notes, counts FROM fyi_links WHERE id > 300; Empty set (0.00 sec)
2007-05-11, 4601👍, 0💬
Popular Posts:
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the rec...
How can I execute a PHP script using command line? Just run the PHP CLI (Command Line Interface) pro...
How do you estimate maintenance project and change requests?
What will the following piece of code do? int f(unsigned int x) { int i; for (i=0; x!=0; x>&a...