MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `test2` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10),
  `hotStatus` tinyint(1),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;
INSERT INTO test2 VALUES
(3 ,  'A'  ,  1 ),
(4 ,  'A'  ,  0 ),
(5 ,  'A'  ,  0 ),
(6 ,  'A'  ,  0 ),
(7 ,  'A'  ,  1 );

Records: 5  Duplicates: 0  Warnings: 0


SELECT * FROM test2;


id
name
hotStatus


3
A
1

4
A
0

5
A
0

6
A
0

7
A
1


SET @name := 'A';
INSERT INTO test2 (NAME, hotStatus)
SELECT @name, 1 
WHERE NOT EXISTS ( SELECT 1 
                   FROM test2 
                   WHERE NAME = @name );

Records: 0  Duplicates: 0  Warnings: 0


SELECT * FROM test2;


id
name
hotStatus


3
A
1

4
A
0

5
A
0

6
A
0

7
A
1


SET @name := 'Z';
INSERT INTO test2 (NAME, hotStatus)
SELECT @name, 1 
WHERE NOT EXISTS ( SELECT 1 
                   FROM test2 
                   WHERE NAME = @name );

Records: 1  Duplicates: 0  Warnings: 0


SELECT * FROM test2;


id
name
hotStatus


3
A
1

4
A
0

5
A
0

6
A
0

7
A
1

8
Z
1