how to alter table column data type
mysql
Solution
ALTER TABLE table_name MODIFY hits bigint(20) unsigned NOT NULL default '0';
Problem
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