xxxxxxxxxx
#create database in python with mysql
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")
xxxxxxxxxx
import pandas as pd
import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
'Server=RON\SQLEXPRESS;'
'Database=test_database;'
'Trusted_Connection=yes;')
df = pd.read_sql_query('SELECT * FROM products', conn)
print(df)
print(type(df))
xxxxxxxxxx
import mysql.connector
from mysql.connector import Error
try:
connection = mysql.connector.connect(host='localhost',
database='Electronics',
user='pynative',
password='pynative@#29')
if connection.is_connected():
db_Info = connection.get_server_info()
print("Connected to MySQL Server version ", db_Info)
cursor = connection.cursor()
cursor.execute("select database();")
record = cursor.fetchone()
print("You're connected to database: ", record)
except Error as e:
print("Error while connecting to MySQL", e)
finally:
if connection.is_connected():
cursor.close()
connection.close()
print("MySQL connection is closed")
xxxxxxxxxx
# Importing module
import mysql.connector
# Creating connection object
mydb = mysql.connector.connect(
host = "localhost",
user = "yourusername",
password = "your_password"
)
# Printing the connection object
print(mydb)
xxxxxxxxxx
import mysql.connector
# Establish connection
conn = mysql.connector.connect(
host="localhost", # MySQL server address
user="your_username", # MySQL username
password="your_password", # MySQL password
database="your_database" # MySQL database name
)
if conn.is_connected():
print("Connected to MySQL database")
# Perform database operations
# ...
# Close the connection
conn.close()
xxxxxxxxxx
import sqlite3
try:
sqliteConnection = sqlite3.connect('test.db')
cursor = sqliteConnection.cursor()
print("SQLITE Connection Established!")
cursor.close()
except sqlite3.Error as error:
print("Error while connecting to sqlite", error)
finally:
if (sqliteConnection):
sqliteConnection.close()
print("Connection closed")
xxxxxxxxxx
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="username",
password="password",
database="database_name"
)
# Now, perform the database task you want to do.
# Happy coding