Cannot add DATETIME columns to MySQL table

Question

I'm trying to add two DATETIME columns to my User_Accounts table.

I create the columns in MySQL workbench like so: DATETIME(6)

What am I doing wrong?

Answer 1

Remove that size specifier (6) from your ALTER statement.

   ALTER TABLE `Chessmates`.`User_Accounts` 
    CHANGE COLUMN `Country` `Country` TEXT(25) NOT NULL ,
    ADD COLUMN `created_at` DATETIME NOT NULL AFTER `salt`,
    ADD COLUMN `updated_at` DATETIME NULL DEFAULT NULL AFTER `created_at`