Collections:
Deleting Multiple Rows from a Table in MySQL
How To Delete Multiple Rows from a Table in MySQL?
✍: 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)
⇒ Deleting All Rows in a Table in MySQL
⇐ Deleting an Existing Row from a Table in MySQL
2018-01-08, 1519🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...