Changing Column in MySQL from int to double?

Here's the real syntax. Make sure to set the nullability appropriately too:

ALTER TABLE your_tableMODIFY COLUMN your_column DOUBLE NULL;

ALTER TABLE your_tableMODIFY COLUMN your_column DOUBLE NOT NULL;

mysql syntax int double

You're right that you need to use ALTER TABLE. The command will look something like this:

ALTER TABLE tablename MODIFY COLUMN columnname DOUBLE;

CodeHunter