How to update a Azure SQL table using python

Question

Hello Experts, I have a requirement to query and update a column in an Azure SQL db using Python. If I use the pyodb I am getting an error. Pandas only support SQLAlChemy.
I tried using SQLAlchemy , but no luck. Please let me know if you have a working example to update some records using python

import pyodbc
server = '<server>.database.windows.net'
database = '<database>'
username = '<username>'
password = '{<password>}'   
driver= '{ODBC Driver 17 for SQL Server}'

with pyodbc.connect('DRIVER='+driver+';SERVER=tcp:'+server+';PORT=1433;DATABASE='+database+';UID='+username+';PWD='+ password) as conn:
    with conn.cursor() as cursor:
        cursor.execute("SELECT TOP 3 name, collation_name FROM sys.databases")
        row = cursor.fetchone()
        while row:
            print (str(row[0]) + " " + str(row[1]))
            row = cursor.fetchone()

Answer 1

Using SQLAlchemy, here you will find how to perform an Update statement?
Below an example using PYODBC:

import pyodbc
server = 'mysql1000.database.windows.net'
database = 'DemoDatabase'
username = 'azureadmin'
password = 'Test@123' 
driver= '{ODBC Driver 17 for SQL Server}'

with pyodbc.connect('DRIVER='+driver+';SERVER=tcp:'+server+';PORT=1433;DATABASE='+database+';UID='+username+';PWD='+ password) as conn:
    with conn.cursor() as cursor:
        cursor.execute("UPDATE [dbo].[Student] SET Stream = 'Electrical' WHERE [Student ID] = 1607")

Here you will find a full CRUD example using PYODBC.