Read from MySQL

[[Deleted]]

I was studying an example code for inserting data from MQL4 into MySQL database. However, can somebody please be so good and show me a correct example of reading the result of a simple query into a variable in MQL4? Thank you!

[dRONCHIKUS]

hunsheridan:
I was studying an example code for inserting data from MQL4 into MySQL database. However, can somebody please be so good and show me a correct example of reading the result of a simple query into a variable in MQL4? Thank you!

Im not an expert really, but I guess if you'd make your own DLL with functions to query MySQL DB and then link it to your MQL code, then you'd be able to do what u want.

[[Deleted]]

andrewk1983:

hunsheridan:
I was studying an example code for inserting data from MQL4 into MySQL database. However, can somebody please be so good and show me a correct example of reading the result of a simple query into a variable in MQL4? Thank you!

Im not an expert really, but I guess if you'd make your own DLL with functions to query MySQL DB and then link it to your MQL code, then you'd be able to do what u want.

I'm sorry I forgot to tell that I'm importing the mysql.dll that comes with the mysql distribution on Windows.

I've already managed to insert data by examining the code 'TicksInMySQL'

It helped me a lot for inserts and now is working perfectly. All I need to figure out is how I get data result of query back from MySQL.

[Mykola Bilak]

one solution is to use query SELECT .. INTO .. text file and then read that file in mql4