how to use mysql.dll to query records from a mysql database ?

[flourishing]

 i have read that ticksin mysql and i know that , insert record to mysql is easy , could anyone please give a example to show how to query records from a database, use "select ..." .  thank you .

[Mike]

No problem. I am ready to do your job. I am very old databases work. I await your those jobs.

[Louis Stoltz]

I would also like to know howto read rows from mysql into mt.

[Bill]

This is a lot harder than it sounds. While I can read/write from MySQL from a DLL, doing it efficiently (without having to activate and terminate the MySQL connection on every tick) is difficult. Be wary of anyone who thinks this is easy. I had to do it with ODBC for performance reasons since the other access methods introduce a lot of overhead. And ODBC is really hard and verbose.