MySQL 8.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.4.3


CREATE TABLE foo (
  data DECIMAL,
  other numeric
);
SHOW CREATE TABLE foo;


Table
Create Table


foo
CREATE TABLE `foo` (
  `data` decimal(10,0) DEFAULT NULL,
  `other` decimal(10,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci