An SQL Tutorial Part 3 - More UPDATE Statements

Now that you know how to use a WHERE clause in a SELECT statement, we can use this same WHERE clause to limit the rows that are updated when using an UPDATE statement.

Lets go back and look at our player table again:

Because I'm not a socialist, I realize that George Lucas should have a whole lot more money than Rick B. Lets write a statement that will fix this obvious problem.

UPDATE player SET credits = 5000000 WHERE player_id = 1;

The above statement will give player 1 (George Lucas) 5000000 credits, as can be seen in the screen shot below:

<< Previous

©2005 Battleline Games
Contact Us: Support@EpochStar.com