import os
import pexpect
os.system('service mysql restart')
try:
print 'create database water ...'
mysql2 = pexpect.spawn('mysql -u root -p', timeout=3)
mysql2.expect("Enter password:")
mysql2.sendline('') # 密码
mysql2.expect('mysql>')
mysql2.sendline('create database %s;' % '') # 数据库名
mysql2.sendcontrol('d')
print 'done ...'
except Exception, e:
print e
python脚本与mysql交互
最新推荐文章于 2022-09-15 14:10:32 发布