Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4507👍, 0💬
Popular Posts:
How will you freeze the requirement in this case? What will be your requirement satisfaction criteri...
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...