Reply to thread

Message: [QUOTE="Rhino, post: 600127"] That is true but it doesn't mean you can simply omit WHERE to get the result you want. For example, if you have 100 rows in a table and each has a unique key, like a customer number, and you do an UPDATE without a WHERE, you will update every one of the rows in that table. Normally, you only want to update specific rows. For example, you may want to update the address for customer #46. To do this, you would write something like this: UPDATE mytable set address = '123 Main Street' where customer_number = 46 If you wrote this instead: UPDATE mytable set address = '123 Main Street' without any WHERE clause, EVERY SINGLE CUSTOMER IN YOUR TABLE will get their address changed to 123 Main Street, not just customer #46. So PLEASE use a WHERE in your UPDATE statement *UNLESS* you really do want to change every row of the table in the same way. Rhino [/QUOTE]