General Community > Scripting Help

MySQL query question

(1/3) > >>

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: ---ALTER TABLE yabbse_members MODIFY avatar TEXT;
--- End code ---

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!!  :o

I did it and it gave me this query


--- Code: ---ALTER TABLE `yabbse_members` CHANGE `avatar` `avatar` TEXT DEFAULT NULL
--- End code ---

thx guys :)

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

Navigation

[0] Message Index

[#] Next page