← Back to team overview

maria-discuss team mailing list archive

newbie question


Guys, i'm with a "newbie" question
I need to swap a primary key value, for example:
create table test (
 id int not null default 0,
  other varchar(255) not null default '',
 primary key(id)
insert into test (1,'a');
insert into test (2,'b');

now i want that (2,'b') becomes (1,'b') and (1,'a') becomes (2,'a')

the point is, how to do this, with only one UPDATE without duplicate column
id value? and without delete values?

Roberto Spadim

Follow ups