By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();
| VERSION() |
|---|
| 8.0.17 |
DROP TABLE IF EXISTS `tbl_kml_data`;
CREATE TABLE IF NOT EXISTS `tbl_kml_data` (
`tbl_id` BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`boundry` POLYGON,
`f_polygon` POLYGON
);
INSERT INTO `tbl_kml_data` (`boundry`)
VALUES
(ST_GeomFromText('POLYGON((6.546269854000059 80.15311213900003,6.54627481600005 80.15298415800004,6.54605968900006 80.15315188800008,6.546251038000038 80.15310380500006,6.546269854000059 80.15311213900003))')),
(ST_GeomFromText('POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327,-74.13591384887695 40.93750722242824))'));
SELECT
`tbl_id`,
ST_AsText(`boundry`),
ST_AsText(`f_polygon`)
FROM `tbl_kml_data`;
| tbl_id | ST_AsText(`boundry`) | ST_AsText(`f_polygon`) |
|---|---|---|
| 1 | POLYGON((6.546269854000059 80.15311213900003,6.54627481600005 80.15298415800004,6.54605968900006 80.15315188800008,6.546251038000038 80.15310380500006,6.546269854000059 80.15311213900003)) | null |
| 2 | POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327,-74.13591384887695 40.93750722242824)) | null |
UPDATE `tbl_kml_data`
SET `f_polygon` = `boundry`;
SELECT
`tbl_id`,
ST_AsText(`boundry`),
ST_AsText(`f_polygon`)
FROM `tbl_kml_data`;
| tbl_id | ST_AsText(`boundry`) | ST_AsText(`f_polygon`) |
|---|---|---|
| 1 | POLYGON((6.546269854000059 80.15311213900003,6.54627481600005 80.15298415800004,6.54605968900006 80.15315188800008,6.546251038000038 80.15310380500006,6.546269854000059 80.15311213900003)) | POLYGON((6.546269854000059 80.15311213900003,6.54627481600005 80.15298415800004,6.54605968900006 80.15315188800008,6.546251038000038 80.15310380500006,6.546269854000059 80.15311213900003)) |
| 2 | POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327,-74.13591384887695 40.93750722242824)) | POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327,-74.13591384887695 40.93750722242824)) |