Connecting MySQL with Different Programming Languages

Here is a brief overview of how to connect MySQL with different programming languages:

1. Python:

   • Use the mysql-connector-python library.

   • Example:

     import mysql.connector
     
     conn = mysql.connector.connect(
         host="localhost",
         user="yourusername",
         password="yourpassword",
         database="yourdatabase"
     )
     cursor = conn.cursor()
     cursor.execute("SELECT * FROM yourtable")
     for row in cursor:
         print(row)
     
     

2. Java:

   • Use the JDBC library.

   • Example:

     import java.sql.Connection;
     import java.sql.DriverManager;
     import java.sql.ResultSet;
     import java.sql.Statement;
     
     public class Main {
         public static void main(String[] args) {
             try {
                 Connection conn = DriverManager.getConnection(
                     "jdbc:mysql://localhost:3306/yourdatabase", "yourusername", "yourpassword");
                 Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery("SELECT * FROM yourtable");
                 while (rs.next()) {
                     System.out.println(rs.getString("columnname"));
                 }
             } catch (Exception e) {
                 e.printStackTrace();
             }
         }
     }
     
     

3. PHP:

   • Use the mysqli extension.

   • Example:

     $conn = new mysqli("localhost", "yourusername", "yourpassword", "yourdatabase");
     
     if ($conn->connect_error) {
         die("Connection failed: " . $conn->connect_error);
     }
     
     $sql = "SELECT * FROM yourtable";
     $result = $conn->query($sql);
     
     if ($result->num_rows > 0) {
         while($row = $result->fetch_assoc()) {
             echo "id: " . $row["id"] . " - Name: " . $row["name"] . "
     ";
         }
     } else {
         echo "0 results";
     }
     $conn->close();
     
     

4. C#:

   • Use the MySql.Data.MySqlClient library.

   • Example:

     using MySql.Data.MySqlClient;
     using System;
     
     class Program {
         static void Main() {
             string connStr = "server=localhost;user=yourusername;database=yourdatabase;port=3306;password=yourpassword";
             MySqlConnection conn = new MySqlConnection(connStr);
     
             try {
                 conn.Open();
                 string sql = "SELECT * FROM yourtable";
                 MySqlCommand cmd = new MySqlCommand(sql, conn);
                 MySqlDataReader rdr = cmd.ExecuteReader();
     
                 while (rdr.Read()) {
                     Console.WriteLine(rdr[0] + " -- " + rdr[1]);
                 }
                 rdr.Close();
             } catch (Exception ex) {
                 Console.WriteLine(ex.ToString());
             }
             conn.Close();
         }
     }
     
     

5. JavaScript (Node.js):

   • Use the mysql package.

   • Example:

     const mysql = require('mysql');
     
     const connection = mysql.createConnection({
         host: 'localhost',
         user: 'yourusername',
         password: 'yourpassword',
         database: 'yourdatabase'
     });
     
     connection.connect();
     
     connection.query('SELECT * FROM yourtable', (error, results, fields) => {
         if (error) throw error;
         console.log(results);
     });
     
     connection.end();
     
     

6. Ruby:

   • Use the mysql2 gem.

   • Example:

     require 'mysql2'
     
     client = Mysql2::Client.new(
         :host => "localhost",
         :username => "yourusername",
         :password => "yourpassword",
         :database => "yourdatabase"
     )
     
     results = client.query("SELECT * FROM yourtable")
     results.each do |row|
         puts row
     end
     
     

7. Perl:

   • Use the DBI module.

   • Example:

     use DBI;
     
     my $dbh = DBI->connect("DBI:mysql:database=yourdatabase;host=localhost",
                            "yourusername", "yourpassword",
                            {'RaiseError' => 1});
     
     my $sth = $dbh->prepare("SELECT * FROM yourtable");
     $sth->execute();
     
     while (my $row = $sth->fetchrow_hashref()) {
         print "id: $row->{id} - Name: $row->{name}\\\\n";
     }
     
     $sth->finish();
     $dbh->disconnect();
     
     

8. Go:

   • Use the go-sql-driver/mysql package.

   • Example:

     package main
     
     import (
         "database/sql"
         "fmt"
         _ "github.com/go-sql-driver/mysql"
     )
     
     func main() {
         db, err := sql.Open("mysql", "yourusername:yourpassword@tcp(127.0.0.1:3306)/yourdatabase")
         if err != nil {
             panic(err)
         }
         defer db.Close()
     
         results, err := db.Query("SELECT * FROM yourtable")
         if err != nil {
             panic(err)
         }
     
         for results.Next() {
             var column1 string
             var column2 string
             err = results.Scan(&column1, &column2)
             if err != nil {
                 panic(err)
             }
             fmt.Println(column1, column2)
         }
     }
     
     

9. Swift:

   • Use the mysql-swift package.

   • Example:

     import MySQL
     
     let connection = try MySQL.Connection(
         host: "localhost",
         user: "yourusername",
         password: "yourpassword",
         database: "yourdatabase"
     )
     try connection.open()
     
     let statement = try connection.prepare(query: "SELECT * FROM yourtable")
     let results = try statement.execute()
     
     for row in results {
         print(row)
     }
     
     connection.close()
     
     

10. R:

    • Use the RMySQL package.

    • Example:

      install.packages("RMySQL")
      library(RMySQL)
      
      con <- dbConnect(MySQL(), user = 'yourusername', password = 'yourpassword', host = 'localhost', dbname = 'yourdatabase')
      
      result <- dbSendQuery(con, "SELECT * FROM yourtable")
      data <- fetch(result)
      
      print(data)
      
      dbDisconnect(con)
      
      

11. Scala:

    • Use the mysql-connector-java library.

    • Example:

      import java.sql.{Connection, DriverManager, ResultSet}
      
      object Main extends App {
          val url = "jdbc:mysql://localhost:3306/yourdatabase"
          val username = "yourusername"
          val password = "yourpassword"
      
          var connection: Connection = null
      
          try {
              connection = DriverManager.getConnection(url, username, password)
      
              val statement = connection.createStatement()
              val resultSet = statement.executeQuery("SELECT * FROM yourtable")
      
              while (resultSet.next()) {
                  println(resultSet.getString("columnname"))
              }
          } catch {
              case e: Exception => e.printStackTrace()
          } finally {
              if (connection != null) {
                  connection.close()
              }
          }
      }
      
      

12. Kotlin:

    • Use the mysql-connector-java library.

    • Example:

      import java.sql.Connection
      import java.sql.DriverManager
      import java.sql.ResultSet
      
      fun main() {
          val url = "jdbc:mysql://localhost:3306/yourdatabase"
          val username = "yourusername"
          val password = "yourpassword"
      
          var connection: Connection? = null
      
          try {
              connection = DriverManager.getConnection(url, username, password)
      
              val statement = connection.createStatement()
              val resultSet = statement.executeQuery("SELECT * FROM yourtable")
      
              while (resultSet.next()) {
                  println(resultSet.getString("columnname"))
              }
          } catch (e: Exception) {
              e.printStackTrace()
          } finally {
              connection?.close()
          }
      }
      
      

13. C++:

    • Use the MySQL Connector/C++ library.

    • Example:

      #include <mysql_driver.h>
      #include <mysql_connection.h>
      #include <cppconn/statement.h>
      #include <cppconn/resultset.h>
      
      int main() {
          sql::mysql::MySQL_Driver *driver;
          sql::Connection *con;
          sql::Statement *stmt;
          sql::ResultSet *res;
      
          driver = sql::mysql::get_mysql_driver_instance();
          con = driver->connect("tcp://127.0.0.1:3306", "yourusername", "yourpassword");
          con->setSchema("yourdatabase");
      
          stmt = con->createStatement();
          res = stmt->executeQuery("SELECT * FROM yourtable");
      
          while (res->next()) {
              std::cout << "id: " << res->getInt("id") << " - Name: " << res->getString("name") << std::endl;
          }
      
          delete res;
          delete stmt;
          delete con;
      
          return 0;
      }
      

14. Dart:

    • Use the mysql1 package.

    • Example:

      import 'package:mysql1/mysql1.dart';
      
      void main() async {
        // Configuration settings
        final settings = ConnectionSettings(
          host: 'your_host',
          port: 3306,
          user: 'your_username',
          password: 'your_password',
          db: 'your_database',
        );
      
        // Establish the connection
        final conn = await MySqlConnection.connect(settings);
        print('Connection established');
      
        // Execute a query
        var results = await conn.query('SELECT * FROM your_table');
      
        // Process the result
        for (var row in results) {
          print('Column: ${row[0]}');
        }
      
        // Close the connection
        await conn.close();
      }