在Windows10上对python 3.6.4和mysql 8使用pymysql时,出现了奇怪的语法错误。然而,这些命令曾经在MySQL5.7中使用,而且它们自己也可以使用。这里有两个例子:
create table Guest(
guestNo INT,
firstName varchar(15),
lastName varchar(15),
phoneNo VARchar(20));
由python print(ex.args)
输出的错误,其中ex是Exception
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create table Guest(\n\t\t guestNo INT,\n firstName varchar(15' at line 2")
另一个例子:
insert into Booking
values (101, '2014-06-01', '2014-06-30', 500);
insert into Booking
values (101, '2014-08-01', '2014-08-31', 500);
insert into Booking
values (102, '2014-07-01', '2014-07-31', 500);
insert into Booking
values (102, '2015-07-01', '2015-07-31', 500);
insert into Booking
values (103, '2014-09-01', '2014-09-30', 500);
由python print(ex.args)
输出的错误,其中ex是Exception
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into Booking\nvalues (101, '2014-06-01', '2014-06-30', 500);\ninsert into B' at line 2")
似乎我可以很好地连接(不使用新的身份验证)。
发布于 2018-06-08 06:01:10
所以,与pymysql的MySQL 5.7不同的是: 1. cursor.exec(q)
。Q必须是一个命令。由分隔的多个命令;无效。2.仔细查看python代码后,它在每个查询之前附加了一个额外的SET @some_var = 0;
,从而将我的查询转换为多语句查询。我希望这对某些人有帮助。
https://stackoverflow.com/questions/50745794
复制相似问题