bdd_python

#coding:utf-8

import pymysql

conn = pymysql.connect(host='localhost',user='axel',password='***',db='rpi_arduino')

cursor = conn.cursor()

sql = 'SELECT etat from `comm_1`;'
cursor.execute(sql)

countrow = cursor.execute(sql)
print('nombre de lignes: ',countrow)
data = cursor.fetchall()
data_str = str(data)
print(data_str.replace("), ","), \n"))