nuke points transfer

registered · Worker Joined: Aug 05, 2005 Posts: 139

hi i need to transfer ll my cash_mod points that has variable user_points into nukes points

here are the table differences

user_points decimal(11,0)

points int(10)

whats the best way to copy the points part over without doing this by hand

thanks

steve

Posted: Thu Oct 13, 2005 7:55 am

should i drop nuke table and rename and drop ?

Posted: Thu Oct 13, 2005 8:02 am

something like this drop field points and do this

ALTER TABLE `nuke_users` CHANGE `user_points` `points` INT( 10 ) NOT NULL DEFAULT '1'

is that best way to do it