1 2 3 4 5 6
| >>> cnx=mysql.connector.connect(user='root',password='',host='localhost',database='kalitsim')
>>> cur=cnx.cursor()
>>> cur.execute("SELECT * FROM fiches")
>>> list(cur)
[(1, 1, 'C-100714-7907', None, None, '', datetime.datetime(2015, 4, 15, 9, 17), 'ALL POs SENT TO ALL TRANSLATORS NL DELIVERED 30/03/15 POR DELIVERED 31/03 DE DELIVERED 09/04 ES EN COURS DE VALIDATION'), (2, 2, 'C-140814-8473', None, None, '', datetime.datetime(2015, 4, 5, 12, 0), 'Denis Hirson et Adine Segalyn will do it'), (3, 3, 'C-140814-8495', datetime.datetime(2015, 3, 13, 13, 23), datetime.datetime(2015, 3, 13, 13, 32), '', datetime.datetime(2015, 3, 2, 9, 0), '1st reread - questions out (13/04) INVOICE 0415306 SENT 14/04 (206.08)'), (4, 4, 'C-140814-8483', None, None, '', datetime.datetime(2015, 4, 20, 14, 23), "FRANCK WILL DO IT ENREGISTREMENT A 8H ENVOYER LE BDC A FRANCK ET L'INSCRIRE DANS KALITERA"), (5, 5, 'C-140814-8483', datetime.datetime(2015, 4, 20, 13, 0), datetime.datetime(2015, 4, 20, 13, 10), '', datetime.datetime(2015, 4, 5, 16, 30), 'CONTACT AND DELIVERY : bquerne@cls.fr (Benjamin QUERNE)')]
>>> |
Partager