Rusty SQL (Rusty is not a person)

TheShniz · Regular Joined: Jan 27, 2004 Posts: 65

My SQL is a wee bit rusty, can some1 gimme a refresher:
The user_msnm field in the nuke_users table is 2 small, what's the proper command 2 redefine that field as say 50 instead of the default of 25?

A guess...
ALTER TABLE `nuke_users` UPDATE `user_msnm` VARCHAR( 50 ) ;

Thanx!
> TheShniz Cool

Raven · Posted: Tue Jun 01, 2004 12:03 pm

Code:

ALTER TABLE `nuke_users` CHANGE `user_msnm` `user_msnm` VARCHAR( 50 );

Or, just use phpMyAdmin Wink

TheShniz · Regular Joined: Jan 27, 2004 Posts: 65

I didn't realise U could w/ phpMyAdmin, HMmmmmmmmmmm... Okie Dokie. Thanx a bunch!

> TheShniz