In MySQL (or SQL in general) is there a way to update a table using operators?
For instance, if I have 10 items in a table and would like to update their primary key ID's where the ID > 7. I would like to do something like this:
update make where id > 7 SET id = id+1;
but can't figure out how. Is this even possible?
Thanks,
john
For instance, if I have 10 items in a table and would like to update their primary key ID's where the ID > 7. I would like to do something like this:
update make where id > 7 SET id = id+1;
but can't figure out how. Is this even possible?
Thanks,
john