I have imported a large excel file into a MySQL table
I want to change a varchar field to a decimal field
I thought the syntax would be
ALTER TABLE tablename ALTER COLUMN columnname DECIMAL (10,2)
but I keep getting a syntax error in SQL
Is such a change permitted or do I have the syntax incorrect
Can someone help?