MySQL 5.5

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

select version();

CREATE TABLE `acc_2020`(  
  `InvDate` DATE,
  `fulldate` VARCHAR(250),
  `AccountID` VARCHAR(250),
  `InvTotExclDEx` FLOAT,
  `mainNAME` VARCHAR(250),
  `Name` VARCHAR(250)
);

INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2017-07-18 00:00:00","2017-07","550","5254.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2017-10-06 00:00:00","2017-10","550","2328.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2017-11-27 00:00:00","2017-11","550","5688.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2018-06-11 00:00:00","2018-06","550","2250.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2018-08-13 00:00:00","2018-08","550","5512.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2018-12-13 00:00:00","2018-12","550","11888.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2019-04-04 00:00:00","2019-04","550","-10622.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2019-05-29 00:00:00","2019-05","550","3125.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;
INSERT INTO `acc_2020` (  `InvDate`,  `fulldate`,  `AccountID`,  `InvTotExclDEx`,  `mainNAME`,  `Name`) 
VALUES  ("2019-06-14 00:00:00","2019-06","550","1185.00","SHOPRITE N/CAPE F/STATE","SHOPRITE MMABATHO") ;

select * from acc_2020;

version()
5.5.62

InvDate	fulldate	AccountID	InvTotExclDEx	mainNAME	Name
2017-07-18	2017-07	550	5254	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2017-10-06	2017-10	550	2328	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2017-11-27	2017-11	550	5688	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2018-06-11	2018-06	550	2250	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2018-08-13	2018-08	550	5512	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2018-12-13	2018-12	550	11888	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2019-04-04	2019-04	550	-10622	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2019-05-29	2019-05	550	3125	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO
2019-06-14	2019-06	550	1185	SHOPRITE N/CAPE F/STATE	SHOPRITE MMABATHO