I will remotely query mysql database and I want to check that the received dataset matches the table in the host computer. How do you do that? I am fairly new to sql database. I know of Checksum and md5, but how do you use them to verify the received dataset is not corrupted on the local machine.
If there is a hardware error in the machine, all sorts of things will be dying, not just your one query.
If you are concerned about the network, see all the checksums, etc, involved in TCP/IP and Ethernet. You don't need a layer of checks on top of that.
If you are asking about consistency between Master and Slave in replication, then say so; that gets into a different area of things.
Bottom line: Don't worry. Resultsets are corrupted about as often as you get hit by a meteorite.