Data Analytics
27K subscribers
1.16K photos
24 videos
26 files
977 links
Dive into the world of Data Analytics – uncover insights, explore trends, and master data-driven decision making.
Download Telegram
πŸ“š Programming Android with Kotlin (2022)

πŸ”— Download Link: https://cuty.io/qgoq7g0

⭐️ Watch the download video successfully

πŸ”‘ Tags: #kotlin #android

βœ… By: @DataScience_Books - @DataScience4 - @EBooks2023
πŸ”₯1
πŸ“š The First Line of Code Android Programming with Kotlin (2022)

πŸ”— Download Link: https://cuty.io/eUwjE5Om

⭐️ Watch the download video successfully

πŸ”‘ Tags: #kotlin

βœ… By: @DataScience_Books - @DataScience4 - @EBooks2023
πŸ”₯1
πŸ“š Building Android Projects with Kotlin (2023)

πŸ”— Download Link: https://file.lu/d/1M4C

πŸ’¬ Tags: #kotlin

⛔️ βž•10 interaction = βž• books

βœ… Click here πŸ‘‰: Surprise 🎁
❀‍πŸ”₯4
πŸ“š Kotlin in Action (2023 - V9)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/117

πŸ’¬ Tags: #kotlin

USEFUL CHANNELS FOR YOU
❀4πŸ‘1
πŸ“š Kotlin (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1538

πŸ’¬ Tags: #Kotlin

πŸ‘‰ BEST DATA SCIENCE CHANNELS ON TELEGRAM πŸ‘ˆ
πŸ‘5
# πŸ“š Connecting MySQL Database with Popular Programming Languages

#MySQL #Programming #Database #Python #Java #CSharp #PHP #Kotlin #MATLAB #Julia

MySQL is a powerful relational database management system. Here’s how to connect MySQL with various programming languages.

---

## πŸ”Ή 1. Connecting MySQL with Python
#Python #MySQL
Use the mysql-connector-python or pymysql library.

import mysql.connector

# Establish connection
conn = mysql.connector.connect(
host="localhost",
user="your_username",
password="your_password",
database="your_database"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

for row in result:
print(row)

conn.close()


---

## πŸ”Ή 2. Connecting MySQL with Java
#Java #JDBC
Use JDBC (Java Database Connectivity).

import java.sql.*;

public class MySQLJava {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/your_database";
String user = "your_username";
String password = "your_password";

try {
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

while (rs.next()) {
System.out.println(rs.getString("column_name"));
}

conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}


---

## πŸ”Ή 3. Connecting MySQL with C# (.NET)
#CSharp #DotNet #MySQL
Use MySql.Data NuGet package.

using MySql.Data.MySqlClient;

string connStr = "server=localhost;user=your_username;database=your_database;password=your_password";
MySqlConnection conn = new MySqlConnection(connStr);

try {
conn.Open();
string query = "SELECT * FROM your_table";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader reader = cmd.ExecuteReader();

while (reader.Read()) {
Console.WriteLine(reader["column_name"]);
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
} finally {
conn.Close();
}


---

## πŸ”Ή 4. Connecting MySQL with PHP
#PHP #MySQL
Use mysqli or PDO.

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo $row["column_name"];
}
} else {
echo "0 results";
}

$conn->close();
?>


---

## πŸ”Ή 5. Connecting MySQL with Kotlin
#Kotlin #JDBC
Use JDBC (similar to Java).

import java.sql.DriverManager

fun main() {
val url = "jdbc:mysql://localhost:3306/your_database"
val user = "your_username"
val password = "your_password"

try {
val conn = DriverManager.getConnection(url, user, password)
val stmt = conn.createStatement()
val rs = stmt.executeQuery("SELECT * FROM your_table")

while (rs.next()) {
println(rs.getString("column_name"))
}

conn.close()
} catch (e: Exception) {
e.printStackTrace()
}
}


---

## πŸ”Ή 6. Connecting MySQL with MATLAB
#MATLAB #Database
Use Database Toolbox.

conn = database('your_database', 'your_username', 'your_password', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/your_database');

data = fetch(conn, 'SELECT * FROM your_table');
disp(data);

close(conn);


---

## πŸ”Ή 7. Connecting MySQL with Julia
#Julia #MySQL
Use MySQL.jl package.

using MySQL

conn = MySQL.connect("localhost", "your_username", "your_password", db="your_database")

result = MySQL.execute(conn, "SELECT * FROM your_table")

for row in result
println(row)
end

MySQL.disconnect(conn)


---
❀5