Reports

In reply to Maurice

Using MySql I use this code:

import mysql.connector
cnx = mysql.connector.connect(user='root', password='Aragorn_2024', 
host='127.0.0.1',  database='Aragorn')
cur = cnx.cursor()
cur.execute("INSERT INTO sakila.tempora SELECT sysdate()")
for row in cur.fetchall():
    print (row[0])
cnxn.close())

Using ODBC, the code looks like this: import pyodbc cnx = pyodbc.connect('DRIVER={Devart ODBC Driver for SQL Server};Server=127.0.0.1;Database=Aragorn;Port=3306;UserID=root;Password=Aragorn_2024') cur = cnx.cursor() cur.execute("INSERT INTO sakila.tempora SELECT sysdate()") for row in cur.fetchall(): print (row[0]) cnxn.close()

79197201