Use an UPDATE statement, such as the following: UPDATE table1 SET cash = cash + 0.10 WHERE id = 123;
A Anonymous Guest Jun 29, 2004 #1 Use an UPDATE statement, such as the following: Code: UPDATE table1 SET cash = cash + 0.10 WHERE id = 123;
Use an UPDATE statement, such as the following: Code: UPDATE table1 SET cash = cash + 0.10 WHERE id = 123;
A Anonymous Guest Jun 30, 2004 #2 Use SELECT to test if the member already has a row. If so, just UPDATE its value. If not, create a new row using INSERT and whatever starting value you want.
Use SELECT to test if the member already has a row. If so, just UPDATE its value. If not, create a new row using INSERT and whatever starting value you want.
