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 Update Values on Multiple Rows
How To Update Values on Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example:
mysql> UPDATE fyi_links SET counts = 9, notes = 'Wrong' WHERE id >= 500; Query OK, 5 rows affected (0.00 sec) Rows matched: 5 Changed: 5 Warnings: 0 mysql> SELECT id, url, notes, counts, DATE(created) FROM fyi_links WHERE id >= 500; +-----+-------------------+-------+--------+---------------+ | id | url | notes | counts | DATE(created) | +-----+-------------------+-------+--------+---------------+ | 601 | moc.retneciyf.ved | Wrong | 9 | 2006-04-30 | | 602 | moc.retneciyf.abd | Wrong | 9 | 2006-08-31 | | 603 | moc.retneciyf.aqs | Wrong | 9 | 2006-08-31 | | 610 | | Wrong | 9 | 2006-08-31 | | 500 | moc.retneciyf.www | Wrong | 9 | 2006-08-31 | +-----+-------------------+-------+--------+---------------+ 5 rows in set (0.00 sec)
This statement updated 5 rows with the same new values on all 5 rows.
2007-05-11, 4768👍, 0💬
Popular Posts:
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
.NET INTERVIEW QUESTIONS - Can we use events with threading ? Yes, you can use events with thread; t...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
What is the result of using Option Explicit? When writing your C program, you can include files in t...
How To Fade Image Edges to Background Colors? - PSP Tutorials - Fading Images to Background Colors w...