cursor.execute() does not support multiple/bulk insert queries

[Mythri Manjunath]

pymysql: cursor.execute() supports multiple query?

insert_statement= "INSERT INTO demo VALUES ('$SYS/publish/messages/received',0,1515580086025);

INSERT INTO demon VALUES ('$SYS/publish/messages/sent',0,1515580086025);

INSERT INTO demon VALUES ('$SYS/publish/messages/sent',3,1515580094997);

INSERT INTO demon VALUES ('$SYS/publish/messages/sent',4,1515580105983);"

cursor.execute(insert_statement):
   

when I try to execute,I get this

 error: (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

[INADA Naoki]

Yes, but you need to pass `client_flag=CLIENT.MULTI_STATEMENT` option
for pymysql.connect().

> --
> You received this message because you are subscribed to the Google Groups
> "PyMySQL Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to pymysql-user...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
INADA Naoki <songof...@gmail.com>

[Mythri Manjunath]

okay thanks a lot . will try with this flag. How many  statements would be supported ? 
MULTI_STATEMENTS = 1 << 16

[INADA Naoki]

I don't know.

It's up to MySQL.

I'm protocol expert, but I don't know much about MySQL or SQL.

2018/01/10 午後10:21 "Mythri Manjunath" <mythr...@gmail.com>:

--

You received this message because you are subscribed to the Google Groups "PyMySQL Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to pymysql-users+unsubscribe@googlegroups.com.