python向mysql导入文件的问题

python如何调用load data infile向mysql导入数据？高手给个例子

这是命令行下能直接执行的命令吗？如果命令行下能执行，用：
os.system
subprocess.call
subprocess.Popen
应该都能实现吧

这里是个linux下执行ping命令的
Python code

[root@RHEL6B pycode]# cat py11.py 
#!/usr/bin/env python

def ping2():
    import os
    import subprocess
    
    fnull = open(os.devnull, 'w')
    return1 = subprocess.call('ping 111.8.8.8 -c 2', shell=True, stdout = fnull, stderr = fnull)
    if return1:
        print 'ping fail'
    else:
        print 'ping ok'
    fnull.close()

if __name__=='__main__':
    ping2()

[root@RHEL6B pycode]# ./py11.py 
ping fail

Python code

[root@RHEL6B pycode]# more py13.py 
#!/usr/bin/env python
#coding:utf-8
from subprocess import Popen, PIPE
return_code=-999 
proc = Popen(['/root/shcode/sleep.sh'], stdout=PIPE, stderr=PIPE)
return_code = proc.wait()
voutput=proc.stdout.read()
if return_code == 0:
    print "Success:\n%s" % voutput 
elif return_code == -999:
    print 'not set:', voutput
else:
    print "Failure %s:\n%s" % (return_code, voutput)

都是这两天的练习代码，直接拷贝贴上来