use test; UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1"); UPDATE matable1 SET nid=nid+1 ORDER BY nid DESC; INSERT INTO matable1 VALUES(1,"XYZ1","ABC1");