add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `test` (
`id` mediumint NOT NULL AUTO_INCREMENT,
`Date_VARCHAR` varchar(30) DEFAULT NULL,
`Date_TIMESTAMP` timestamp(6) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52383 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
INSERT INTO test (`Date_VARCHAR`)
VALUES('2021-05-10T08-45-30'), ('2021-05-10T08-46-30'), ('2021-05-10T08-47-30'), ('2021-05-10T08-48-30');
SELECT * FROM test;
Records: 4  Duplicates: 0  Warnings: 0
id Date_VARCHAR Date_TIMESTAMP
52383 2021-05-10T08-45-30 null
52384 2021-05-10T08-46-30 null
52385 2021-05-10T08-47-30 null
52386 2021-05-10T08-48-30 null