How to interact with MYSQL database from within perl program

Bassam · 02-26-2004, 09:14 AM

Hello Guys,
I have MYSQL database that contains a number of tables, and I am using PERL programming under Linux redahat 9.0, so any one can tell me how can I INSERT, DELETE, UPDATE the recordes of a specific table in my database by using PERL programming?

the name of the table id IP_LAN and it contains the follwoing fields:
NODE_IP
NODE_GW
NODE_MAC

Thanks for HELP
Bassam

acid_kewpie · 02-26-2004, 10:04 AM

http://search.cpan.org/~rudy/DBD-mys...b/DBD/mysql.pm

Bassam · 02-26-2004, 10:41 AM

Thank acid_kewpie. That was in PERL, but what about C/C++, how can I access the MYSQL database by using C/C++ programming under Linux readhat 9.0 ????

dford · 02-26-2004, 04:28 PM

There is a C API included with the MySQL Server.

The overall documentation page is:
http://www.mysql.com/documentation/m...ter/index.html

The C API page is:
http://www.mysql.com/documentation/m...Clients.html#C

MySQL++ is the C++ API for MySQL. Check out http://www.mysql.com/products/mysql++/

chewysplace · 02-26-2004, 04:44 PM

thnx dford, been looking for something like that myself

acid_kewpie · 02-26-2004, 05:00 PM

Quote:

Originally posted by Bassam
Thank acid_kewpie. That was in PERL, but what about C/C++, how can I access the MYSQL database by using C/C++ programming under Linux readhat 9.0 ????

of course it was perl.. that was you requested