Requirement 1 : You have SQL script ready to insert the data but your table has date column with hdifferent format, then how
                              to use existing query to insert data. Try using STR_TO_DATE(), as show below -
                     ​Insert into EMP
   (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL)
 Values
   ('7369', 'SMITH', 'CLERK', '7902', STR_TO_DATE('17-DEC-80', '%d-%M-%Y'), '800');