By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| @@sql_mode |
|---|
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
| Table | Create Table |
|---|---|
| acquisition | CREATE TABLE `acquisition` ( `id` int NOT NULL, `received` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `parsed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Records: 4 Duplicates: 0 Warnings: 0
| id | received | parsed |
|---|---|---|
| 1 | 2023-01-20 13:07:12 | 2023-01-21 13:07:12 |
| 2 | 2023-01-22 13:07:12 | 0000-00-00 00:00:00 |
| 3 | 0000-00-00 00:00:00 | 2023-01-23 13:07:12 |
| 4 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 |
Records: 0 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
| Table | Create Table |
|---|---|
| acquisition | CREATE TABLE `acquisition` ( `id` int NOT NULL, `received` timestamp NULL DEFAULT NULL, `parsed` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
| id | received | parsed |
|---|---|---|
| 1 | 2023-01-20 13:07:12 | 2023-01-21 13:07:12 |
| 2 | 2023-01-22 13:07:12 | 0000-00-00 00:00:00 |
| 3 | 0000-00-00 00:00:00 | 2023-01-23 13:07:12 |
| 4 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 |
Rows matched: 4 Changed: 3 Warnings: 0
| id | received | parsed |
|---|---|---|
| 1 | 2023-01-20 13:07:12 | 2023-01-21 13:07:12 |
| 2 | 2023-01-22 13:07:12 | null |
| 3 | null | 2023-01-23 13:07:12 |
| 4 | null | null |