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();