Python Mysql insert

Connect mysql ด้วย python


#!/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)

#!/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)