When inserting data in bulk, parsing parameter errors were found about mysql_async HOT 3 CLOSED

@wengchengjian, hi.

It seems that you've overlooked the corresponding section in the docs.

tldr; parameter name convention (almost) follows the rust variable identifier convention. Let me cite:

• parameter name must start with either _ or a..z
• parameter name may continue with _, a..z and 0..9

from mysql_async.

@blackbeam Sorry, I couldn't reply to your message in a timely manner. I already understand what you mean, but I have encountered another problem. When using the batch function, it feels inefficient, like executing SQL one by one.

from mysql_async.

@wengchengjian, yeah. I believe this was previously discussed somewhere in mysql_async or rust-mysql-common issues. Long story short - batch execution is in fact executes SQL one by one. To speed things up you have to build a large query yourself, or consider using LOAD DATA .. (in case of many inserts)

from mysql_async.