MySQL query question

[Anguz]

this is the first time I actually try my luck with mysql, so forgive me if the question is silly 

if I want to change the avatar column in yabbse_members table, from tinytext to text, would this query be ok?

Code Select Expand

ALTER TABLE yabbse_members MODIFY avatar TEXT;

[Haase]

Is there any reason you need to do this in script?  The easiest thing to do would be to go in via phpMyAdmin and change it that way.

[Anguz]

well... I know

but this is for a mod I have almost complete, I need to give the query for others to do it too... maybe do a script to do it even, dunno

but I do need to be sure it's the correct query before using it in the mod

[Spaceman-Spiff]

if you do it in phpmyadmin, it will tell you the SQL code too

[Anguz]

great! I didn't know!! 

I did it and it gave me this query

Code Select Expand

ALTER TABLE `yabbse_members` CHANGE `avatar` `avatar` TEXT DEFAULT NULL

thx guys

I'll release the new mod a bit later today then

[[Unknown]]

phpMyAdmin: never fails

Wrong .

-[Unknown]

[[Unknown]]

well, you can never argue with [Unknown]

Wrong .

-[Unknown]

[[Unknown]]

im always wrong  

Wrong .

LOL.

-[Unknown]

[[Unknown]]

LOL... this is getting silly 

Bingo!!!!  CORRECT!

-[Unknown]

[Anguz]

yeah!!!

it's working!! I've done it!!

I'll post it in Completed Mods in a few and will put a link here to the thread

but you can have a peek here
http://llama.lewismedia.com/~anguz/forums/index.php?action=viewprofile;user=webmaster

[Anguz]

here it is 

Built-in Avatar Randomizer

thanks for your help guys

[Shoeb Omar]

oooh cool mod

[Anguz]

thx!

my members are starting to love it! since it makes it very easy for them to have the avatar script without having a server or knowing code, etc

if you have any comments on it, please post them in the mod's thread... I'd love to have some feedback