Connect mysql ด้วย python
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
#!/usr/bin/python import mysql.connector import string dbuser = 'xxxx' dbname = 'mydb' dbpass = 'xxxxx' dbhost = '127.0.0.1' def initmysql(): conn = mysql.connector.connect(user=dbuser,password=dbpass, host=dbhost, database=dbname) return conn def insertsql(conn,strsql): cur = conn.cursor() cur.execute(strsql) conn.commit() cur.close() def closemysql(conn): conn.close #___ main___ conn = initmysql() add_profile = ( "insert into profile " "values (%s, '%s', '%s', '%s','%s', '%s')") for x in range (10,20): name = "sznote%s"%(x) sname = name type = "man" add_data = (x,name,sname,'man','single','41211') str = add_profile%(add_data) print str insertsql(conn,str) |