mysql点保存没反应_python,mysql_python调用mysql存储过程没有反应，python,mysql - phpStudy...

python调用mysql存储过程没有反应

建表:

drop table if exists `Account`;

CREATE TABLE `Account` (

`id` BIGINT(20) NOT NULL,

`Name` VARCHAR(100) NOT NULL,

`pwd` VARCHAR(100) NOT NULL,

`times` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0'

)ENGINE=InnoDB

插入数据:

INSERT INTO `Account` (`id`, `Name`, `pwd`, `times`) VALUES

(1, 'Messiah', '59data', 0),

(2, 'zmx', 'data', 0),

(3, '59store', '盖亚', 1);

建立储存过程:

DELIMITER //

DROP PROCEDURE IF EXISTS `proctest`//

CREATE PROCEDURE`proctest`()

BEGIN

insert into Account

VALUES(5,'盖亚','59store',9);

END //

Python 脚本:

#!/usr/bin/env python

# -*- coding