1. Install MySQLdb in ubuntu.
3. Edit the file
with mysql with phpmyadmin, we can see that the table has a new row with 'wangyi1e' and 28.
sudo apt-get install python-MySQLdb
2. create a new python file
vim mysql_learn.py
3. Edit the file
#!/usr/bin/env python
# coding=utf-8
import MySQLdb
# mysql user name
userName = 'root'
# mysql user password
password = 'password'
try:
# connect to local mysql
conn = MySQLdb.connect(host='localhost', user=userName, passwd=password, port=3306)
cur = conn.cursor()
# create new database 'python_test'
cur.execute('create database if not exists python_test')
# select the database
conn.select_db('python_test')
# create table with name and age.
cur.execute('create table p_test(name varchar(20), age int)')
value=['wangyi1e', 28]
cur.execute('insert into p_test values(%s, %s)',value)
# commit here is very import for mysql to storage the action.
conn.commit()
cur.close()
conn.close()
except MySQLdb.Error, e:
print("Call Failure %d:%s"%(e.args[0], e.args[1]))
with mysql with phpmyadmin, we can see that the table has a new row with 'wangyi1e' and 28.