By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Table1 (Sum int, Count int, Name1 varchar(10), Address1 varchar(10), Zip1 varchar(10));
create table Table2 (Name varchar(10), Address varchar(10), Zip varchar(10));
insert into Table2 (Name, Address, Zip) values
('Name1', 'Address1', 'Zip1'),
('Name2', 'Address2', 'Zip2'),
('Name3', 'Address3', 'Zip3'),
('Name4', 'Address4', 'Zip4');
Records: 4 Duplicates: 0 Warnings: 0
SET @rownum:=0;
SET @sum:=0;
INSERT INTO Table1 (Count, Sum, Name1, Address1, Zip1)
SELECT @rownum:=(@rownum+1), @sum:=(@sum+@rownum),
Name, Address, Zip
FROM Table2;
Records: 4 Duplicates: 0 Warnings: 0
SELECT * FROM Table1;
| Sum | Count | Name1 | Address1 | Zip1 |
|---|---|---|---|---|
| 1 | 1 | Name1 | Address1 | Zip1 |
| 3 | 2 | Name2 | Address2 | Zip2 |
| 6 | 3 | Name3 | Address3 | Zip3 |
| 10 | 4 | Name4 | Address4 | Zip4 |