Qfyilyi

I have a code in python that export mysql to csv file here is the output.
im also using python 3.6

b'USER1'|b'rona1'|b'pass1'

b'USER2'|b'rona2'|b'pass2'

b'USER3'|b'rona3'|b'pass3'

and i want the output is

USER1|rona1|pass1

USER2|rona2|pass2

USER3|rona3|pass3

Here is my code in python:

import mysql.connector

from UnicodeSupportForCsv import UnicodeWriter

import csv

import sys



config = {'user': 'root',

'password': 222222,

'host': 'localhost',

'port':221,'database': 

'server_mysql_sample',

'raise_on_warnings': True

}



connect = mysql.connector.connect(**config)

dbquery='Select * from tbl_user;'

conn = mysql.connector.connect(**config)

crsr = conn.cursor()

crsr.execute("SELECT * FROM tbl_user")

with open(r'test.csv', 'wb') as csvfile:

    uw = UnicodeWriter(

        csvfile, delimiter='|',quotechar='"', quoting=csv.QUOTE_NONE)



    for row in crsr.fetchall():

        uw.writerow([str(col) for col in row])

then i used the unicodewriter from https://docs.python.org/2/library/csv.html
and i remove data = data.decode("utf-8") to make it work.
but the output is b'text'|b'text'|b'text'