It is very important to know information about compatible as well as up-to-date connectors and APIs before performing database connections and operations.
Also read: Introduction To MySQL Full-Text Search
What is MySQL a Connector?
MySQL Connectors are the piece of software that provides connectivity between a programming language and MySQL server and APIs provide low-level access to MySQL resources.
MySQL Provides different connectors for different programming languages such as JDBC and ODBC for Java, Python-MySQL, C, C++, Ruby, and NodeJS connectors.
What is MySQL an API?
API stands for application programming interface and refers to a collection of programming instructions (through classes, methods, functions, and variables) and standards for interacting with a web-based software application or online utility.
Procedural and object-oriented APIs are two types of APIs. In a procedural API, you execute functions to do tasks, but in an object-oriented API, you create classes and then call methods on the objects that result. The second interface is frequently favored over the first since it is more current and results in more ordered code.
List of MySQL Connectors and APIs
Here is the list of all MySQL connectors and APIs that are developed by either MySQL company or the MySQL community.
Tutorials on MySQL Connectors and APIs
PHP-MySQL
In this set of tutorials, you will learn to connect a PHP program to a MySQL server using multiple methods such as object-oriented MySQLi, procedural MySQLi, and PDO.
You can jump on any tutorial by clicking below.
- connecting PHP to mysql database
- Create Table
- Insert Data
- Insert Multiple Records
- Prepared Statements
- Fetch Data
- Update Data
- Delete Data
NodeJS-MySQL
In this tutorial, you will learn how to install the required packages for connecting a NodeJs program to MySQL using NPM which is a node package manager.
Java JDBC-MySQL
You can connect a Java program to MySQL using ODBC as well. However, we will see how to connect, insert, fetch, update and delete using the Java JDBS driver.
Python-MySQL
In this tutorial, we will see how to install a mysql-python connector to connect a python program to a MySQL server using a PIP which is a package manager for python.
- Python-MySQL overview and introduction
- Connecting Python to MySQL
- Insert Data
- Fetch Data
- Update Data
- Delete Data
Perl-MySQL
In this tutorial, we will learn how to connect a perl program to the MySQL server by using database driver for perl. We will start from downloading the required packages using CPAN.