Sep-25-2022, 10:49 PM
Hi Team,
I am using below piece of code for writing SQL Data into csv file. size of data is big. 60gb
I want to create a generic function dynamically for writing data into function
for row in rows:
csvwriter.writerow(row)
I am using below piece of code for writing SQL Data into csv file. size of data is big. 60gb
I want to create a generic function dynamically for writing data into function
for row in rows:
csvwriter.writerow(row)
import csv cursor = connection.cursor() cursor.execute('SELECT * FROM employee') filename = "abc.csv" Data = [] # writing to csv file with open(filename, 'w',newline = '') as csvfile: csvwriter = csv.writer(csvfile) csvwriter.writerow(col[0] for col in cursor.description) while True: rows = cursor.fetchmany(10000) print(rows) if len(rows) ==0: break else: for row in rows: csvwriter.writerow(row) cursor.close() connection.close()