Rusty SQL (Rusty is not a person)

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

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Code:

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

Or, just use phpMyAdmin Wink

Posted: Tue Jun 01, 2004 12:59 pm

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

> TheShniz