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, 1735🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...