Question

how program like java,python,c,cpp,perl interfaced with sql ?

Answer 1

each program uses a driver usually written in that language to send queries and commands to the database.

Answer 2

You have drivers for each language,Look into the respective sites ,you will get.
E.G
http://sourceforge.net/projects/mysql-python/ =>driver for python
http://stackoverflow.com/questions/623276/best-resource-for-mysql-python-2-6-programming

Answer 3

drivers or libraries, clases like C# can use LINQ