MySQL SQL - How To Delete Multiple Rows from a Table

How To Delete Multiple Rows from a Table

Q

How To Delete Multiple Rows from a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements

✍: FYIcenter.com

A

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, 4309👍, 0💬

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, My... 2007-05-11, 4583👍, 0💬

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 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 t... 2007-05-11, 4310👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: mysql> INSERT INT... 2007-05-11, 4275👍, 0💬

What Is a SELECT Query Statement
What Is a SELECT Query Statement? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY The SELECT statement is also called the query statement. It is the most frequently used SQL statement in any database application. A SELECT statement allows you to retrieve data from one or more tables or view... 2007-05-11, 4187👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.