python个人学习小技巧数据库Mssql 操作

最新推荐文章于 2023-06-19 02:24:33 发布

Yatere

最新推荐文章于 2023-06-19 02:24:33 发布

阅读量1.6k

点赞数

分类专栏： python 文章标签： python 数据库 database table query insert

python 专栏收录该内容

203 篇文章

订阅专栏

本文详细介绍了使用Python操作MSSQL数据库的过程，包括连接数据库、执行SQL查询、创建表、插入数据以及删除表的操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MssqlConn

import pymssql
con = pymssql.connect(host="computerName\\SQLEXPRESS",user="sa",password="telesys",database="jadsTest")

print con
cursor = con.cursor( )
print  cursor
# Execute an SQL string
sql = "SELECT * FROM test1"
cursor.execute(sql)
# Fetch all results from the cursor into a sequence and close the connection
results = cursor.fetchall( )
columns = results[0:1000000]
MAX_ROWS = len(results[0])
print columns
print MAX_ROWS
print "<table>"
for field in columns:
print "<tr>"
for k in range(MAX_ROWS):
print "<td>", field[k], "</td>"
print "</tr>"
print "</table>"
for des in cursor.description: print des

one = cursor.fetchone()
print one
con.close( )

 

MssqlCreate

#import mssql
import pymssql,cPickle
con = pymssql.connect(host="SHARDSERVER\\SQLEXPRESS",user="sa",password="telesys",database="jadsTest")
print con

cur= con.cursor()
print  cur

query="create table pymssql (no int, fno float, comment varchar(50));"
print cur.execute(query)
print "create table: %d" % cur.rowcount

for x in range(10):
query="insert into pymssql (no,fno,comment) values (%d,%d.%d,'%dth comment');" % (x+1,x+1,x+1,x+1)
ret=cur.execute(query)
print ret
print "insert table: %d" % cur.rowcount

con.commit()

 

Mssqldrop

import pymssql,cPickle
con = pymssql.connect(host="SHARDSERVER\\SQLEXPRESS",user="sa",password="telesys",database="jadsTest")
print con

cur= con.cursor()
print  cur

query="drop table test2;"
cur.execute(query)
print "drop table: %d" % cur.rowcount

con.commit()