How to operate sybase iq database in python

How to operate sybase iq database in python, in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

#! / usr/env/bin python

-*-coding:utf-8-*-

# Import database connection module

Import sqlanydb

User='dba'

Passwd='hwfx123'

Host='localhost:5000'

_ sql = "" select getdate () ""

# Connect to the database

Con = sqlanydb.connect (userid=user, password=passwd, host=host)

# execute SQL statement

Cur = con.cursor ()

Cur.execute (_ sql)

# get the execution result

Current_date = cur.fetchall () [0]

Print 'current date is', current_date

Cur.close ()

Con.close ()

This is the answer to the question about how to operate the sybase iq database in python. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.