MySQL 8.0

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

CREATE TABLE test (ID INT, CUSTOMER_ID INT, CUSTOMER_NAME VARCHAR(255));
SET @data := '
[  { "ID": 5464015,
     "CUSTOMER_ID": 1088020,
     "CUSTOMER_NAME": "My customer 1"
   },
   { "ID": 5220812,
     "CUSTOMER_ID": 523323,
     "CUSTOMER_NAME": "My customer 2"
   },
   { "ID": 5205039,
     "CUSTOMER_ID": 1934806,
     "CUSTOMER_NAME": "My customer 3"
   }
]
';
INSERT INTO test
SELECT *
FROM JSON_TABLE(@data,
                "$[*]" COLUMNS( ID INT PATH "$.ID",
                                CUSTOMER_ID INT PATH "$.CUSTOMER_ID",
                                CUSTOMER_NAME VARCHAR(255) PATH "$.CUSTOMER_NAME")
               ) AS jsontable;

Records: 3  Duplicates: 0  Warnings: 0


SELECT * FROM test;


ID
CUSTOMER_ID
CUSTOMER_NAME


5464015
1088020
My customer 1

5220812
523323
My customer 2

5205039
1934806
My customer 3

ID	CUSTOMER_ID	CUSTOMER_NAME
5464015	1088020	My customer 1
5220812	523323	My customer 2
5205039	1934806	My customer 3