[SOLVED] Code for ALTER TABLE
Posted: Tue Feb 10, 2004 2:55 pm
Can somone tell me what the syntax is for using an ALTER TABLE command to set a mySQL column type to be BINARY?
Can you do it the same way you set a type to be an INTEGER, for example...
If the column field name is column1,
I've tried:
"ALTER TABLE CHANGE column1 column1 BINARY"
Doesn't seem to wotk
thanks,
--Tim
Can you do it the same way you set a type to be an INTEGER, for example...
If the column field name is column1,
I've tried:
"ALTER TABLE CHANGE column1 column1 BINARY"
Doesn't seem to wotk
thanks,
--Tim