python import oursql conn = oursql.connect(host='localhost', user='root', passwd='password', db='database') with open('data.csv', 'rb') as file: cursor = conn.cursor() cursor.execute('LOAD DATA LOCAL INFILE ? INTO TABLE table_name CHARACTER SET utf8 FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\r\ \' IGNORE 1 LINES', (file.name,)) conn.commit() cursor.close() conn.close() python import oursql conn = oursql.connect(host='localhost', user='root', passwd='password', db='database') with open('output.csv', 'wb') as file: cursor = conn.cursor() cursor.execute('SELECT * INTO OUTFILE ? FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\r\ \' FROM table_name', (file.name,)) conn.commit() cursor.close() conn.close()