I have Query With Me (Just Facing Some Problems With Dates) :
INSERT INTO `tenancyschedule` (`tenant_id`, `Property_id`, `property_name`, `Shop_Identifier`, `tenant_name`, `Gross_Lettable_Areas`, `Lease_Expiry_Date`, `Annual_Base_Rent`, `Annual_Outgoings`, `Annual_promotions`, `Annual_other_charges`, `Total_Annual_Gross_Rent_incl_Promo`, `Annual_Base_Rent_psm`, `Annual_Outgoings_psm`, `Annual_promotions_psm`, `Annual_other_charges_psm`, `Total_Annual_Gross_Rent_psm`, `Outgoings_payable`, `Lease_Start_Date`, `Rent_Review_Date`, `Lease_Terms_yrs`, `Rent_free_month`, `Incentive`, `Options`, `Base_escalation`, `Promotion_terms`, `Turnover_rent_percent`, `Turn_over_rule`, `Comments_text`) VALUES
(1, 1, 'Banora', '1', 'BWS', '120.00', '0000-00-00 00:00:00', '103139.43', '0.00', '0.00', '0.00', '103139.43', '859.50', '0.00', '0.00', '0.00', '859.50', 'Semi-Gross', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 0, '0.00', '2 x 5', 'CPI', 'NV', '0.00', 'NV', ''),
(2, 1, 'Banora', '2+3', 'WHSmith Newsagent', '154.00', '0000-00-00 00:00:00', '133705.69', '0.00', '0.00', '0.00', '133705.69', '868.22', '0.00', '0.00', '0.00', '868.22', 'Gross', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 0, '0.00', '0', '0.05', 'NV', '0.08', '$5m plus 5% each year', ''),
(3, 1, 'Banora', '4', 'Blooms The Chemist', '398.00', '0000-00-00 00:00:00', '350000.00', '35859.85',