自己分享一个Python连接MySQL的Sample。这里面query了所有Ticker的信息。
代码如下
本帖隐藏的内容
- import mysql.connector
- import csv
- if __name__ == '__main__':
- try:
- database = mysql.connector.connect(user='***', password='****', database='DB', host="***")
- cursor = database.cursor()
- except mysql.connector.Error as err:
- print(err)
- else:
- OutputFile = open('Ticker.csv', 'wt')
- getQuery = "SELECT Ticker FROM DB.table"
- cursor.execute(getQuery)
- temp = cursor.fetchall()
- Tickers = []
- for ticker in temp:
- tickerreg = str(ticker[0])
- if not tickerreg in Tickers:
- Tickers.append(tickerreg)
- with OutputFile as csvfile:
- fwriter = csv.writer(csvfile, delimiter=',')
- for ticker in Tickers:
- fwriter.writerow([ticker])
- OutputFile.close()
- cursor.close()
- database.close()