from sqlalchemy import create_engine
from consts import DB_URI
eng = create_engine(DB_URI)
with eng.connect() as con:
con.execute('drop table if exists users')
con.execute('create table users(Id INT PRIMARY KEY AUTO_INCREMENT, '
'Name VARCHAR(25))')
con.execute("insert into users(name) values('xiaoming')")
con.execute("insert into users(name) values('wanglang')")
rs = con.execute('select * from users')
for row in rs:
print row
consts.py的代码为(用python驱动可以正常连接数据库并操作):
HOSTNAME = 'localhost'
DATABASE = 'john'
USERNAME = 'root'
PASSWORD = '123'
DB_URI = 'mysql://{}:{}@{}/{}'.format(USERNAME, PASSWORD, HOSTNAME, DATABASE)
出现如下警告:
Python27\lib\site-packages\sqlalchemy\engine\default.py:469: Warning: Incorrect string value: '\xD6\xD0\xB9\xFA\xB1\xEA...' for column 'VARIABLE_VALUE' at row 479
cursor.execute(statement, parameters)
(1L, 'xiaoming')
(2L, 'wanglang')
Process finished with exit code 0
数据库为mysql5.7版本
不明白为什么会出现警告,求大神解答!!