MYSQL change user id manually

[FrozenCreations]

if someone would make a hack of this...! i would love em 2 no extent!

(i added you 2 icq... )

[Andreas]

Sorry, but what the Hell are you guys trying to do?

If you really want to change the Userids you will need a whole bunch of queries.
(Really not worth it)

[FrozenCreations]

well, still, i would like to have it done!

and im trying 2 change the userids...

1>4
1<4

[Marco van Herwaarden]

Maybe too late but....DON'T EVEN TRY THIS!!!!!!!!!

:ermm: Hopefully he listened my warning that I didn't really know what could happen!

[Andreas]

Originally Posted by MarcoH64

Maybe too late but....DON'T EVEN TRY THIS!!!!!!!!!

At least not if you don't know exactly what you are doing ... it's a hell of a job to do.

[FrozenCreations]

i have my own bacup server dont worrie.. i test all my crap on that b4 i do it 4 real

y? what could it have done?

[Marco van Herwaarden]

The userid is referenced in a dozen tables (and even on some places where it is not just a column called 'userid'), and all would need to be changed at once without any conflicts.

Furthermore changing the userid serves no purpose at all it is just an internal number.

I would say that the chance that you F... Up is about 99%.

[Andreas]

Purpose = It's better for his Ego being Userid #1

[FrozenCreations]

yup, kerby got it and besides.. i the head admin.. and when i go to other sites.. i usually go 2 userid #1 , thats all