Collections:
Deleting an Existing Row from a Table in MySQL
How To Delete an Existing Row from a Table in MySQL?
✍: FYIcenter.com
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 INTO fyi_links (url, id) VALUES ('www.myspace.com', 301); Query OK, 1 row affected (0.00 sec) mysql> SELECT id, url, notes, counts FROM fyi_links WHERE id = 301; +-----+-----------------+-------+--------+ | id | url | notes | counts | +-----+-----------------+-------+--------+ | 301 | www.myspace.com | NULL | NULL | +-----+-----------------+-------+--------+ 1 row in set (0.00 sec) mysql> DELETE FROM fyi_links WHERE id = 301; Query OK, 1 row affected (0.00 sec) mysql> SELECT id, url, notes, counts FROM fyi_links WHERE id = 301; Empty set (0.00 sec)
⇒ Deleting Multiple Rows from a Table in MySQL
⇐ Error: Subquery Returns More than 1 Row in MySQL
2018-01-08, 1461🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...