Python database related (sqlserver/sqlite/mysql/access)

1 . Connect SQL Server with pymssql.

1), Pymssql's PyPI address: Https://pypi.python.org/pypi/pymssql.

2), pymssql official website: http://pymssql.org/.

3), Python uses pymssql to connect to the SQL Server database.

2 . Connect SQLite with Sqlite3 module. Starting with Python 2.5, the sqlite3 becomes a built-in module without additional installation.

1), official documents: https://docs.python.org/2/library/sqlite3.html.

2), using Python for SQLite database operation.

3. Python + MySQL.

4. Python Gets the Access table field name.

Walker * 2015-04-24 * * *

This article is from "Walker's Journal" blog, please be sure to keep this source http://walkerqt.blog.51cto.com/1310630/1637802

Python database related (sqlserver/sqlite/mysql/access)