sql转csv文件

insert into tab1 select * from tab21
如果表不存在：
create table tab1 as select * from tab2

WHERE times_tamp>="2021-01-05 00:00" AND times_tamp <"2021-01-06 00:00" 

create table result001 as select * from result where create_time>="2021-02-01 12:00:00" and create_time<"2021-03-01 12:00:00";


select * from result where create_time>="2021-02-01 12:00:00" and create_time<"2021-03-01 12:00:00";



mysql -uroot -pPassword2! -h127.0.0.1




import pymysql
import csv
import codecs
def get_conn():
  conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='Password2!', db='recommendation-ai', charset='utf8')
  return conn
def query_all(cur, sql, args):
  cur.execute(sql, args)
  return cur.fetchall()
def read_mysql_to_csv(filename):
  with codecs.open(filename=filename, mode='w', encoding='utf-8') as f:
    write = csv.writer(f, dialect='excel')
    conn = get_conn()
    cur = conn.cursor()
    sql = 'select * from result where create_time>="2021-02-01 12:00:00" and create_time<"2021-03-01 12:00:00";'
    results = query_all(cur=cur, sql=sql, args=None)
    for result in results:
      print(result)
      write.writerow(result)
if __name__ == '__main__':
  read_mysql_to_csv('2.csv')