write mariadb table rows query to each file?

[shams]

I want to query table pop and write each row to a deferent file, this is code, but the code write the last row to all three files:

# Create a cursor object 
cur  = conn.cursor() 
query = f"SELECT user, passwd,server FROM pop"
cur.execute(query)
for row in cur:
	list1 = ['1', '2', '3']
	for i in range(len(list1)):
		f = open('mail%s' % i, 'w')  
		print(row[0],row[1],row[2], file=f)

[buran]

you write 3 files for every row, overwriting previous files

cur  = conn.cursor() 
query = "SELECT user, passwd, server FROM pop"
cur.execute(query)
for idx, row in enumerate(cur, start=1):
   with open(f'mail{idx}.txt', 'w') as f:
        f.write(','.join(row))

---

I added 'w' mode to open - it was mistake on my part