How to get number of rows affected / row count after multiple insert statement execution

[Mythri Manjunath]

pymysql.connect(host, username, password, database, port, client_flag= CLIENT.MULTI_STATEMENTS|CLIENT.MULTI_RESULTS)

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);"

row_count = cursor.execute(insert_statement)

print (row_count) -> #always prints 1 (but actually 4 rows are inserted as per insert_statement)

print (cursor.rowcount) -> #always prints 1 (but actually 4 rows are inserted as per insert_statement)