Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
GeXus
- Forum Regular
- Posts: 631
- Joined: Sat Mar 11, 2006 8:59 am
Post
by GeXus »
Is there a way to add a value to a record on update? So like update table set col + 1?
-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
yes.
-
GeXus
- Forum Regular
- Posts: 631
- Joined: Sat Mar 11, 2006 8:59 am
Post
by GeXus »
Do tell

-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
You can find an example on the
UPDATE Syntax page.