redshift export to csv

Tags: echo temp table out date table position Date MIT BuildCreate a new TXT file The contents are as follows @echo off sqlplus abc/[email protected] @c:\users\administrator\desktop\abc.sql exit When you are finished, change the file suffix to. bat, and the abc.sql is executed when you double-click Note: 1, "abc/[email protected]" should be changed to Customer "username/password @ database name" 2, C:\Users\Administrator\Desktop\abc.sql is the storage location of Abc.sql

=%sand Q.date_acct =%s) as Revok) D "" "Try#连接MySQL数据库conndb= MySQLdb.connect ("rdsq99sy52dvv160hz76w.mysql.rds.aliyuncs.com", "Sysdba", "UubeeDBmydb1", "Dbchkbill")conndb.select_db (' Dbchkbill ')CURSQL1 = Conndb.cursor ()#查询商户Cursql1.execute (Sqlstr1,checkacc_date)Paycustid = Cursql1.fetchall ()If Len (Paycustid) Print (' No found Checkbill data,please check the data for%s! ' %checkacc_date)Exit (1)For row in Paycustid:CustID = row[0]#创建汇总日账单文件名称FileName = '%s/jymxsum_%s_%s.csv '% (filedir,cu