Blog For Python Professional

  Setup For Work step 1: Install pgadmin4 in your system (Note* please remember root password)   step 2: create a database in the name 'test-all' step 3: create a virtual environment (if you don't know then  visit here ) step 4: pip install psycopg2 step 5: Now create a python script and try with the below code Code Connecting Database: import psycopg2 def connect_my_db (db, user, password, host):     try:         connection = psycopg2.connect(         database=db, user = user,          password = password, host = host,          port = "5432")         print("Database Connected")                    return  connection     except Exception as e:         print("Unable to connect DB") connection   =  connect_my_db ('test-all', 'postgres', '12345', '127.0.0...

Setup For Work SQLite3 comes with python by default. So, you don't need to install it explicitly. Now create a python script and try with the below code. Connecting Database [ db_connect.py ]: import sqlite3 def create_db():     try:          connection  = sqlite3.connect('test.db')    # if test.db is there then it will connect or it will create a new           return  connection     except(sqlite3.DatabaseError, sqlite3.ProgrammingError):         print("DB Connection Error") connection   =  connect_my_db () Create Table : import sqlite3 import db_connect connection   =  connect_my_db () cursor_object = connection.cursor() query = ''' CREATE TABLE  DemoTable  (username text, mail text, phone text, id integer); ''' try:     cursor_object.execute(query)     print("Table created successfully") except Exception as e:   ...

  Setup For Work step 1: Install MySQL in your system (Note* please remember root password)   step 2: create a database in the name 'db10' step 3: create a virtual environment (if you don't know then  visit here ) step 4: pip install mysql-connector-python step 5: Now create a python script and try with the below code Code Connecting Database: import psycopg2 import mysql.connector def connect_my_db (db, user, password, host):     try:         connection = mysql.connector.connect(         database=db, user = user,          password = password, host = host,          port = "3306")         print("Database Connected")         return connection     except Exception as e:         print("Unable to connect DB") connection = connect_my_db('db10', 'root', '12345', 'localhost') Create Table : import mysql.conn...