[Resolved] Leading zeroes in MySQL

[Jammin3k]

I've got a TINYINT column in a MySQL database that has leading zeros that I didn't want... I created the column with "TINYINT UNSIGNED ZEROFILL" and I'm assuming the ZEROFILL tag must be why those zeros are there. I could easily drop the table and make a create a new one without using ZEROFILL, but then I'd lose all the data that's already in the table.
Example: "9" shows up as "009"

My question is: How do I alter the column to get rid of those leading zeros without losing the data? I tried using the ALTER and CHANGE commands but I couldn't get the syntax to work... I think I'm on the right track, but I can't figure out the right syntax, or something. (I've done a lot with MSAccess/ASP, but I'm fairly new to PHP/MySQL...)

Any help is apprecaited...

Thanks in advance,
-Ben

[stolzyboy]

get www.phpmyadmin.net

and it will help you do what you want, you just point and click

[RedDragon]

ALTER TABLE tablename CHANGE fieldnamefieldname` TINYINT UNSIGNED

[Jammin3k]

stolzyboy: Thanks for the link, but that Admin tool is too big to upload to the particular server I'm dealing with... I'll keep it handy for future use though.

RedDragon: that's it! What I was trying was close, I just missed a few little things. Problem solved.

Many thanks