how to alter table column data type [closed]

Question

I've the following column

hits text NOT NULL

and want to alter it to

hits bigint(20) unsigned NOT NULL default '0'

how to use ALTER TABLE commands to do this change ! ~ thanks

Answer 1

ALTER TABLE table_name MODIFY hits bigint(20) unsigned NOT NULL default '0';