Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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)
2007-05-11, 4673👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred? - MySQL FAQs - Transaction Management: C...
What are some uses of Intranets & Extranets? An "intranet" is the generic term for a collect...
Can an anonymous class be declared as implementing an interface and extending a class? An anonymous ...
What is the sequence of UML diagrams in project? First let me say some fact about this question, you...
1. The basics first, please define the web in simple language? How is it connected with internet? Wh...