python命令行方式操作数据库

import sys, os;mysqlcli = "mysql -hx.x.x.x  -Pxx -uxxxx -pxxxxxx databasename";sql = "show tables";(pipein, pipeout) = os.popen4(mysqlcli, "rw");pipein.write(sql);pipein.close();ret = pipeout.readlines();if ret:    print "result:\n", "".join(ret);pipeout.close();