By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `test` (
`id` INT,
`countryCode` VARCHAR(50),
`state` VARCHAR(50)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE = UTF8MB4_0900_AI_CI;
insert into `test` values (1,'AE','AE'),(2,'SA','SA'),
(3,NULL,'SA')
;
SELECT
*
FROM
`test`;
SELECT ('id|countryCode|state|') AS `line`
UNION ALL SELECT
CONCAT(CONCAT(`id`, '|'),
CONCAT(`countryCode`, '|'),
CONCAT(`state`, '|')) AS `line`
FROM
`test`;
| id | countryCode | state |
|---|---|---|
| 1 | AE | AE |
| 2 | SA | SA |
| 3 | null | SA |
| line |
|---|
| id|countryCode|state| |
| 1|AE|AE| |
| 2|SA|SA| |
| null |