By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS mytable (
ID INT,
SN VARCHAR(20),
RESULT1 VARCHAR(2),
RESULT2 VARCHAR(2),
RESULT3 VARCHAR(2)
);
INSERT INTO mytable (ID, SN, RESULT1, RESULT2, RESULT3)
WITH RECURSIVE seq AS
(SELECT 'I' result, 0 AS value
UNION ALL
SELECT 'I' result, value + 1 FROM seq LIMIT 10
)
SELECT 1, 'PKR123456789', result, result, result FROM seq;
SELECT * FROM mytable;
Records: 10 Duplicates: 0 Warnings: 0
| ID | SN | RESULT1 | RESULT2 | RESULT3 |
|---|---|---|---|---|
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |
| 1 | PKR123456789 | I | I | I |