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)
2018-01-08, 735👍, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...