[EMAIL PROTECTED] wrote:
> the code is below:
> import pymssql
> conn = pymssql.connect(host = "121.198.126.233",user = "xxxx",password
> = "xxxx",database = "test")
> print "connecting success"
> cursor = conn.cursor()
> cursor.execute("insert into bbs_test values(%s,%s,%s,%s,%s)",
> ("1","nju","9:13","ustc","test"))
> cursor.close()
> conn.close()
> in the idle:
> connecting success
>
> then i get into the database :test and find that there is nothing in
> the table bbs_test.
> i don't know why
Because you did not commit your changes with conn.commit().
Peter
--
http://mail.python.org/mailman/listinfo/python-list
