ystrigathe

because updates & join don\'t really work together, i think i\'d like to alter table xyz add new_id int default null; update xyz set new_id = ... // changing positions update table xyz set id = id * (-1) where new_id is not null; // change values of keys (i think, id is primary key or at least unique) update table xyz set id = new_id where new_id is not null; // only update for changed records...

if u deleted some records, the data file will contain a \'hole\'. If u insert a new record mysql will re-use these \'holes\'. So you have no chance to get control over this behaviour \'til you take the source and build the engine new. But how do you check for the order? A select-statement doesn\'t say anything about the physically order in the files; it\'s just in which order mysql proceeds the records... By the way: in most databases there\'s a possibility to defrag & re-organize your tables. But in this case, the new records will find a place at the end of the data file...

just try it with \'\': update item set number2=\'$string2\' where ...

physically into the files? no way...

Netscape & Post worked, but on IE I had the same problems... Thanks for this article - after hours of searching (and giving up all hope) - I got it.