multi-insert get error.
Query = "INSERT INTO `test_table` (id, code, start_date) VALUES (1,\'EURUSD\',\'2014.01.01 00:00:01\');";
Query = Query + "INSERT INTO `test_table` (id, code, start_date) VALUES (2,\'EURJPY\',\'2014.01.02 00:02:00\');";
Query = Query + "INSERT INTO `test_table` (id, code, start_date) VALUES (3,\'USDJPY\',\'2014.01.03 03:00:00\');";
Error of multiple statements: 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 ...
Make sure you have set multi statement client flag on database connection opening.
int ClientFlag = CLIENT_MULTI_STATEMENTS; // Setting the multi-statements flag
DB = MySqlConnect(Host, User, Password, Database, Port, Socket, ClientFlag); // Connection to the database
it supports DML, DDL, DCL commands of SQL and, of course, SELECT
Make sure you have MQLMySQL.dll & MQLMySQL.def files located in your folder "C:\Users\Admin\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\MQL5\libraries\"
As you can see if you are running MQL programs in Tester mode, the path to libs would be different (because of UAC)
I'm using the same dll and def files in the agents paths, but the  error persists. It wasn't a problem exclusive to the tester.
I use MySql to store tick data. But i can write only 1000 rows. How can i remove this limit? Can you help me?
There is no limits, please check your logic to store ticks. if you are uses multistatement mode, there are only limit for command buffer size, so you may split your queries by 100 commands and use transactions.
Unfortunately I cannot reproduce this situation right now. but usually error 126 raises when dll cannot be loaded/found. Is it works fine in regular mode (not in tester) ?
Thanks for the answer.
It worked after I updated the version of OpenSSL. Thanks for listening.