Home

Use python script to communication mysql:

Install python-mysql:

opkg update
opkg install python-mysql

nano mysql.py

#!/usr/bin/python
# -*- coding: utf-8 -*-
import _mysql
import sys
try:
    	con = _mysql.connect('192.168.0.20', 'root', 'password', 'books')
    	#con.query("SELECT VERSION()")
    	#result = con.use_result()
    	#print "MySQL version: %s" %  result.fetch_row()[0]
	con.query("INSERT INTO authors (id,name,email) VALUES(3,'python','[email protected]')")    
except _mysql.Error, e:  
    	print "Error %d: %s" % (e.args[0], e.args[1])
    	sys.exit(1)
finally:   
    	if con:
        		con.close()