[SOLVED] Editing all values in a row by a curtain number
Posted: Wed Jul 20, 2005 6:07 am
Hi, i was just wondering if there was a way to edit all values in a row in a mysql database. any help appriciated. sorry if this question is simple, i must just not be noticing something.
heres an example.
Database
Table example1
ID, Name, Lastname, Number
1, John, Smith, 3
2, David, Spring, 1
etc
im wondering if theres a way to increase all numbers in the number column by 3 for example so itll be
Table example1
ID, Name, Lastname, Number
1, John, Smith, 6
2, David, Spring, 4
etc
thanks for any help.
heres an example.
Database
Table example1
ID, Name, Lastname, Number
1, John, Smith, 3
2, David, Spring, 1
etc
im wondering if theres a way to increase all numbers in the number column by 3 for example so itll be
Table example1
ID, Name, Lastname, Number
1, John, Smith, 6
2, David, Spring, 4
etc
thanks for any help.