13_Python_DataBase_Connectivity/Python_Database_Connection.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1cd5a9d5-72e2-4325-81a3-123299be6152",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Installing libraries\n",
    "!pip install ipython-sql\n",
    "\n",
    "!pip install prettytable==0.7.2\n",
    "\n",
    "# Driver \n",
    "!pip install mysql-connector-python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6acdeab0-6c0f-4dc8-926f-d149ca81df6e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "0f5f9df9-cad7-467a-acba-679c3531a09d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The sql extension is already loaded. To reload it, use:\n",
      "  %reload_ext sql\n"
     ]
    }
   ],
   "source": [
    "#\n",
    "\n",
    "%load_ext sql\n",
    "%sql mysql+mysqlconnector://root:root@localhost/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "88683ce2-7b2d-4508-bfcf-02708b12c45c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6148f2d7-bee2-43df-92c8-00f83d139f50",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * mysql+mysqlconnector://root:***@localhost/\n",
      "(mysql.connector.errors.ProgrammingError) 1046 (3D000): No database selected\n",
      "[SQL: show tables;]\n",
      "(Background on this error at: https://sqlalche.me/e/20/f405)\n"
     ]
    }
   ],
   "source": [
    "%%sql\n",
    "show tables;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6302cd5e-a7d8-489c-b1c9-9f37c3940f8a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}