MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE iPadFunctionAccess (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `groupLevel` INT(11) NOT NULL,
  `insideBranchAccess` TINYINT(4) NOT NULL DEFAULT '0',
  `outsideBranchAccess` TINYINT(4) NOT NULL DEFAULT '0',
  `ipadFunctionID` VARCHAR(10) NULL DEFAULT NULL,
  `createdBy` VARCHAR(50) NOT NULL,
  `createdAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` VARCHAR(50) NULL DEFAULT NULL,
  `updatedAt` TIMESTAMP NULL DEFAULT NULL,
  `approvedBy` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `iPadFunction_Group_Unique` (`groupLevel` ASC, `ipadFunctionID` ASC) VISIBLE
 );
INSERT INTO iPadFunctionAccess 
(groupLevel, insideBranchAccess, outsideBranchAccess, ipadFunctionID, createdBy, approvedBy) 
VALUES 
(5, false, true, 'IIU.A05', 'SYSTEM', 'SYSTEM') 
ON DUPLICATE KEY UPDATE 
insideBranchAccess = VALUES(insideBranchAccess), 
outsideBranchAccess = VALUES(outsideBranchAccess), 
createdBy = VALUES(createdBy);
SELECT groupLevel, insideBranchAccess, outsideBranchAccess, ipadFunctionID, createdBy, approvedBy FROM iPadFunctionAccess;


groupLevel
insideBranchAccess
outsideBranchAccess
ipadFunctionID
createdBy
approvedBy


5
0
1
IIU.A05
SYSTEM
SYSTEM


INSERT INTO iPadFunctionAccess 
(groupLevel, insideBranchAccess, outsideBranchAccess, ipadFunctionID, createdBy, approvedBy) 
VALUES 
(5, true, outsideBranchAccess, 'IIU.A05', 'SYSTEM', 'SYSTEM') 
ON DUPLICATE KEY UPDATE 
insideBranchAccess = VALUES(insideBranchAccess), 
outsideBranchAccess = COALESCE(VALUES(outsideBranchAccess), outsideBranchAccess),
createdBy = VALUES(createdBy);
SELECT groupLevel, insideBranchAccess, outsideBranchAccess, ipadFunctionID, createdBy, approvedBy FROM iPadFunctionAccess;


groupLevel
insideBranchAccess
outsideBranchAccess
ipadFunctionID
createdBy
approvedBy


5
1
0
IIU.A05
SYSTEM
SYSTEM