ALTER TABLE tbl_name CHANGE old_col_name new_col_name columntype
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares? Code Samples | People Counting System
A new type to change the column into (not recommended for populated tables)
so yes, your syntax is correct.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares? Code Samples | People Counting System