Python3.5连接Mysql-9262317

q66262

"D:\Program Files (x86)\Python35-32\python.exe" "F:/zuoye/堡垒机实例以及数据库操作/Python MySQL API/使用sqlalchemy连接mysql.py"　　
2016-08-06 14:11:14,070 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'sql_mode'
　　
2016-08-06 14:11:14,070 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,099 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()
　　
2016-08-06 14:11:14,100 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,156 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
　　
2016-08-06 14:11:14,157 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,187 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
　　
2016-08-06 14:11:14,187 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,216 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
　　
2016-08-06 14:11:14,216 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,245 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
　　
2016-08-06 14:11:14,245 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,304 INFO sqlalchemy.engine.base.Engine DESCRIBE `address`
　　
2016-08-06 14:11:14,304 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,332 INFO sqlalchemy.engine.base.Engine ROLLBACK
　　
2016-08-06 14:11:14,360 INFO sqlalchemy.engine.base.Engine DESCRIBE `user`
　　
2016-08-06 14:11:14,360 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,389 INFO sqlalchemy.engine.base.Engine ROLLBACK
　　
2016-08-06 14:11:14,418 INFO sqlalchemy.engine.base.Engine
　　
CREATE TABLE user (
　　id INTEGER NOT NULL AUTO_INCREMENT,
　　name VARCHAR(20),
　　fullname VARCHAR(40),
　　PRIMARY KEY (id)
　　
)
　　

　　

　　
2016-08-06 14:11:14,418 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,448 INFO sqlalchemy.engine.base.Engine COMMIT
　　
2016-08-06 14:11:14,476 INFO sqlalchemy.engine.base.Engine
　　
CREATE TABLE address (
　　id INTEGER NOT NULL AUTO_INCREMENT,
　　user_id INTEGER,
　　email VARCHAR(128) NOT NULL,
　　PRIMARY KEY (id),
　　FOREIGN KEY(user_id) REFERENCES user (id)
　　
)
　　

　　

　　
2016-08-06 14:11:14,476 INFO sqlalchemy.engine.base.Engine {}
　　
2016-08-06 14:11:14,536 INFO sqlalchemy.engine.base.Engine COMMIT
　　

　　
Process finished with exit code 0