025.SQL basic.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: mysql-connector-python in c:\\users\\nayak\\appdata\\local\\programs\\python\\python310\\lib\\site-packages (8.0.29)\n",
      "Requirement already satisfied: protobuf>=3.0.0 in c:\\users\\nayak\\appdata\\local\\programs\\python\\python310\\lib\\site-packages (from mysql-connector-python) (3.20.1)\n"
     ]
    }
   ],
   "source": [
    "!pip install mysql-connector-python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import mysql.connector as conn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "mydb = conn.connect(host = 'localhost',user = 'root' ,passwd = \"root\" )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<mysql.connector.connection_cext.CMySQLConnection at 0x1f9f37ddc30>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor = mydb.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute(\"show databases\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('information_schema',),\n",
       " ('mysql',),\n",
       " ('performance_schema',),\n",
       " ('sakila',),\n",
       " ('sys',),\n",
       " ('testineuron',),\n",
       " ('world',)]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor = mydb.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "ename": "DatabaseError",
     "evalue": "1007 (HY000): Can't create database 'testineuron'; database exists",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mMySQLInterfaceError\u001b[0m                       Traceback (most recent call last)",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\connection_cext.py:535\u001b[0m, in \u001b[0;36mCMySQLConnection.cmd_query\u001b[1;34m(self, query, raw, buffered, raw_as_string)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=533'>534</a>\u001b[0m         query \u001b[39m=\u001b[39m query\u001b[39m.\u001b[39mencode(\u001b[39m'\u001b[39m\u001b[39mutf-8\u001b[39m\u001b[39m'\u001b[39m)\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=534'>535</a>\u001b[0m     \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_cmysql\u001b[39m.\u001b[39;49mquery(query,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=535'>536</a>\u001b[0m                        raw\u001b[39m=\u001b[39;49mraw, buffered\u001b[39m=\u001b[39;49mbuffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=536'>537</a>\u001b[0m                        raw_as_string\u001b[39m=\u001b[39;49mraw_as_string,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=537'>538</a>\u001b[0m                        query_attrs\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_query_attrs)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=538'>539</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n",
      "\u001b[1;31mMySQLInterfaceError\u001b[0m: Can't create database 'testineuron'; database exists",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mDatabaseError\u001b[0m                             Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\nayak\\Desktop\\SelfProject\\iNeuron\\Python\\025.SQL basic.ipynb Cell 9'\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> <a href='vscode-notebook-cell:/c%3A/Users/nayak/Desktop/SelfProject/iNeuron/Python/025.SQL%20basic.ipynb#ch0000008?line=0'>1</a>\u001b[0m cursor\u001b[39m.\u001b[39;49mexecute(\u001b[39m\"\u001b[39;49m\u001b[39mcreate database testineuron\u001b[39;49m\u001b[39m\"\u001b[39;49m)\n",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\cursor_cext.py:269\u001b[0m, in \u001b[0;36mCMySQLCursor.execute\u001b[1;34m(self, operation, params, multi)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=264'>265</a>\u001b[0m             \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mProgrammingError(\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=265'>266</a>\u001b[0m                 \u001b[39m\"\u001b[39m\u001b[39mNot all parameters were used in the SQL statement\u001b[39m\u001b[39m\"\u001b[39m)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=267'>268</a>\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=268'>269</a>\u001b[0m     result \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_cnx\u001b[39m.\u001b[39;49mcmd_query(stmt, raw\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_raw,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=269'>270</a>\u001b[0m                                  buffered\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_buffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=270'>271</a>\u001b[0m                                  raw_as_string\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_raw_as_string)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=271'>272</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=272'>273</a>\u001b[0m     \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mget_mysql_exception(msg\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39mmsg, errno\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39merrno,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=273'>274</a>\u001b[0m                                      sqlstate\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39msqlstate)\n",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\connection_cext.py:540\u001b[0m, in \u001b[0;36mCMySQLConnection.cmd_query\u001b[1;34m(self, query, raw, buffered, raw_as_string)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=534'>535</a>\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_cmysql\u001b[39m.\u001b[39mquery(query,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=535'>536</a>\u001b[0m                        raw\u001b[39m=\u001b[39mraw, buffered\u001b[39m=\u001b[39mbuffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=536'>537</a>\u001b[0m                        raw_as_string\u001b[39m=\u001b[39mraw_as_string,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=537'>538</a>\u001b[0m                        query_attrs\u001b[39m=\u001b[39m\u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_query_attrs)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=538'>539</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=539'>540</a>\u001b[0m     \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mget_mysql_exception(exc\u001b[39m.\u001b[39merrno, msg\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39mmsg,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=540'>541</a>\u001b[0m                                      sqlstate\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39msqlstate)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=541'>542</a>\u001b[0m \u001b[39mexcept\u001b[39;00m \u001b[39mAttributeError\u001b[39;00m:\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=542'>543</a>\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_unix_socket:\n",
      "\u001b[1;31mDatabaseError\u001b[0m: 1007 (HY000): Can't create database 'testineuron'; database exists"
     ]
    }
   ],
   "source": [
    "cursor.execute(\"create database testineuron\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('create table testineuron.ineuron(studentid INT(10) ,firstname VARCHAR(30)  ,lastname VARCHAR(30) ,regid INT(10) ,classname VARCHAR(30))') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('use  testineuron')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('show tables')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('ineuron',)]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('insert into testineuron.ineuron values(423423 , \"sudh\" , \"kumar\" , 2344323 , \"FSDS\")')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "mydb.commit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute(\"select * from  testineuron.ineuron\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(423423, 'sudh', 'kumar', 2344323, 'FSDS'),\n",
       " (564576, 'suhghfdh', 'kumar', 2344323, 'FSDS')]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('insert into testineuron.ineuron values(564576 , \"suhghfdh\" , \"kumar\" , 2344323 , \"FSDS\")')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('create table testineuron.glassdata(col1 INT(10) ,col2 float(10,5),col3 float(10,5) ,col4 float(10,5) , col5 float(10,5),col6 float(10,5) ,clo7 float(10,5) , col8 float(10,5) , col9 float(10,5) , col10 float(10,5) , col11 INT(10)) ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('use testineuron')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('show tables')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('glassdata',), ('ineuron',)]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " Volume in drive C has no label.\n",
      " Volume Serial Number is 022C-3D66\n",
      "\n",
      " Directory of c:\\Users\\nayak\\Desktop\\SelfProject\\iNeuron\\Python\n",
      "\n",
      "12-05-2022  14:34    <DIR>          .\n",
      "11-05-2022  21:37    <DIR>          ..\n",
      "11-05-2022  21:35    <DIR>          .ipynb_checkpoints\n",
      "07-03-2022  00:17            23,057 000.python basic.ipynb\n",
      "13-04-2022  22:44            23,471 001.python basic.ipynb\n",
      "13-04-2022  22:52            16,952 002.whileloop.ipynb\n",
      "16-04-2022  00:46            17,533 003.Forloop.ipynb\n",
      "16-04-2022  01:42            39,935 004.python string and list manupulation.ipynb\n",
      "16-04-2022  02:15            69,090 004.python string and list manupulation-nov.ipynb\n",
      "16-04-2022  02:08            56,644 005.list manupulaton.ipynb\n",
      "16-04-2022  02:54            54,898 006.TUPLE SET AND DICT-bckup.ipynb\n",
      "16-04-2022  02:44            59,358 006.Tuples , set , dict .ipynb\n",
      "16-04-2022  03:12            27,917 007.Function in pyton  (1).ipynb\n",
      "16-04-2022  03:24         9,562,697 008.Function and files.ipynb\n",
      "16-04-2022  16:35            23,880 009.logging and debuging.ipynb\n",
      "16-04-2022  22:13            28,599 010.class and object.ipynb\n",
      "16-04-2022  22:53            14,087 011.file sysetm.ipynb\n",
      "16-04-2022  22:58        21,685,762 012.iterator generator.ipynb\n",
      "16-04-2022  23:40            10,152 013.Exception handling class 1.ipynb\n",
      "17-04-2022  00:01            31,318 014.Exception handling class 2 (1).ipynb\n",
      "16-04-2022  23:59             4,052 015.logging (1).ipynb\n",
      "17-04-2022  00:07             4,053 016.logging (1).ipynb\n",
      "17-04-2022  00:10            33,508 017.oops class 1.ipynb\n",
      "17-04-2022  00:30            39,947 018.oops 29th .ipynb\n",
      "17-04-2022  00:33            41,225 019.oops 30th.ipynb\n",
      "17-04-2022  01:01            38,986 020.oops 2 (2).ipynb\n",
      "11-05-2022  21:50            48,670 021.if else , for loop.ipynb\n",
      "11-05-2022  21:50            25,286 022.for loops while loop.ipynb\n",
      "11-05-2022  21:57            49,806 023.practice problem python basic.ipynb\n",
      "12-05-2022  01:35            11,903 024.glass.data\n",
      "12-05-2022  01:36            80,341 025.SQL basic.ipynb\n",
      "11-05-2022  21:51                36 README.md\n",
      "12-05-2022  13:23        22,104,536 XTUSetup.exe\n",
      "              30 File(s)     54,227,699 bytes\n",
      "               3 Dir(s)  421,036,261,376 bytes free\n"
     ]
    }
   ],
   "source": [
    "ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "file  = open(\"024.glass.data\" , 'r')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1,1.52101,13.64,4.49,1.10,71.78,0.06,8.75,0.00,0.00,1\n",
      "2,1.51761,13.89,3.60,1.36,72.73,0.48,7.83,0.00,0.00,1\n",
      "3,1.51618,13.53,3.55,1.54,72.99,0.39,7.78,0.00,0.00,1\n",
      "4,1.51766,13.21,3.69,1.29,72.61,0.57,8.22,0.00,0.00,1\n",
      "5,1.51742,13.27,3.62,1.24,73.08,0.55,8.07,0.00,0.00,1\n",
      "6,1.51596,12.79,3.61,1.62,72.97,0.64,8.07,0.00,0.26,1\n",
      "7,1.51743,13.30,3.60,1.14,73.09,0.58,8.17,0.00,0.00,1\n",
      "8,1.51756,13.15,3.61,1.05,73.24,0.57,8.24,0.00,0.00,1\n",
      "9,1.51918,14.04,3.58,1.37,72.08,0.56,8.30,0.00,0.00,1\n",
      "10,1.51755,13.00,3.60,1.36,72.99,0.57,8.40,0.00,0.11,1\n",
      "11,1.51571,12.72,3.46,1.56,73.20,0.67,8.09,0.00,0.24,1\n",
      "12,1.51763,12.80,3.66,1.27,73.01,0.60,8.56,0.00,0.00,1\n",
      "13,1.51589,12.88,3.43,1.40,73.28,0.69,8.05,0.00,0.24,1\n",
      "14,1.51748,12.86,3.56,1.27,73.21,0.54,8.38,0.00,0.17,1\n",
      "15,1.51763,12.61,3.59,1.31,73.29,0.58,8.50,0.00,0.00,1\n",
      "16,1.51761,12.81,3.54,1.23,73.24,0.58,8.39,0.00,0.00,1\n",
      "17,1.51784,12.68,3.67,1.16,73.11,0.61,8.70,0.00,0.00,1\n",
      "18,1.52196,14.36,3.85,0.89,71.36,0.15,9.15,0.00,0.00,1\n",
      "19,1.51911,13.90,3.73,1.18,72.12,0.06,8.89,0.00,0.00,1\n",
      "20,1.51735,13.02,3.54,1.69,72.73,0.54,8.44,0.00,0.07,1\n",
      "21,1.51750,12.82,3.55,1.49,72.75,0.54,8.52,0.00,0.19,1\n",
      "22,1.51966,14.77,3.75,0.29,72.02,0.03,9.00,0.00,0.00,1\n",
      "23,1.51736,12.78,3.62,1.29,72.79,0.59,8.70,0.00,0.00,1\n",
      "24,1.51751,12.81,3.57,1.35,73.02,0.62,8.59,0.00,0.00,1\n",
      "25,1.51720,13.38,3.50,1.15,72.85,0.50,8.43,0.00,0.00,1\n",
      "26,1.51764,12.98,3.54,1.21,73.00,0.65,8.53,0.00,0.00,1\n",
      "27,1.51793,13.21,3.48,1.41,72.64,0.59,8.43,0.00,0.00,1\n",
      "28,1.51721,12.87,3.48,1.33,73.04,0.56,8.43,0.00,0.00,1\n",
      "29,1.51768,12.56,3.52,1.43,73.15,0.57,8.54,0.00,0.00,1\n",
      "30,1.51784,13.08,3.49,1.28,72.86,0.60,8.49,0.00,0.00,1\n",
      "31,1.51768,12.65,3.56,1.30,73.08,0.61,8.69,0.00,0.14,1\n",
      "32,1.51747,12.84,3.50,1.14,73.27,0.56,8.55,0.00,0.00,1\n",
      "33,1.51775,12.85,3.48,1.23,72.97,0.61,8.56,0.09,0.22,1\n",
      "34,1.51753,12.57,3.47,1.38,73.39,0.60,8.55,0.00,0.06,1\n",
      "35,1.51783,12.69,3.54,1.34,72.95,0.57,8.75,0.00,0.00,1\n",
      "36,1.51567,13.29,3.45,1.21,72.74,0.56,8.57,0.00,0.00,1\n",
      "37,1.51909,13.89,3.53,1.32,71.81,0.51,8.78,0.11,0.00,1\n",
      "38,1.51797,12.74,3.48,1.35,72.96,0.64,8.68,0.00,0.00,1\n",
      "39,1.52213,14.21,3.82,0.47,71.77,0.11,9.57,0.00,0.00,1\n",
      "40,1.52213,14.21,3.82,0.47,71.77,0.11,9.57,0.00,0.00,1\n",
      "41,1.51793,12.79,3.50,1.12,73.03,0.64,8.77,0.00,0.00,1\n",
      "42,1.51755,12.71,3.42,1.20,73.20,0.59,8.64,0.00,0.00,1\n",
      "43,1.51779,13.21,3.39,1.33,72.76,0.59,8.59,0.00,0.00,1\n",
      "44,1.52210,13.73,3.84,0.72,71.76,0.17,9.74,0.00,0.00,1\n",
      "45,1.51786,12.73,3.43,1.19,72.95,0.62,8.76,0.00,0.30,1\n",
      "46,1.51900,13.49,3.48,1.35,71.95,0.55,9.00,0.00,0.00,1\n",
      "47,1.51869,13.19,3.37,1.18,72.72,0.57,8.83,0.00,0.16,1\n",
      "48,1.52667,13.99,3.70,0.71,71.57,0.02,9.82,0.00,0.10,1\n",
      "49,1.52223,13.21,3.77,0.79,71.99,0.13,10.02,0.00,0.00,1\n",
      "50,1.51898,13.58,3.35,1.23,72.08,0.59,8.91,0.00,0.00,1\n",
      "51,1.52320,13.72,3.72,0.51,71.75,0.09,10.06,0.00,0.16,1\n",
      "52,1.51926,13.20,3.33,1.28,72.36,0.60,9.14,0.00,0.11,1\n",
      "53,1.51808,13.43,2.87,1.19,72.84,0.55,9.03,0.00,0.00,1\n",
      "54,1.51837,13.14,2.84,1.28,72.85,0.55,9.07,0.00,0.00,1\n",
      "55,1.51778,13.21,2.81,1.29,72.98,0.51,9.02,0.00,0.09,1\n",
      "56,1.51769,12.45,2.71,1.29,73.70,0.56,9.06,0.00,0.24,1\n",
      "57,1.51215,12.99,3.47,1.12,72.98,0.62,8.35,0.00,0.31,1\n",
      "58,1.51824,12.87,3.48,1.29,72.95,0.60,8.43,0.00,0.00,1\n",
      "59,1.51754,13.48,3.74,1.17,72.99,0.59,8.03,0.00,0.00,1\n",
      "60,1.51754,13.39,3.66,1.19,72.79,0.57,8.27,0.00,0.11,1\n",
      "61,1.51905,13.60,3.62,1.11,72.64,0.14,8.76,0.00,0.00,1\n",
      "62,1.51977,13.81,3.58,1.32,71.72,0.12,8.67,0.69,0.00,1\n",
      "63,1.52172,13.51,3.86,0.88,71.79,0.23,9.54,0.00,0.11,1\n",
      "64,1.52227,14.17,3.81,0.78,71.35,0.00,9.69,0.00,0.00,1\n",
      "65,1.52172,13.48,3.74,0.90,72.01,0.18,9.61,0.00,0.07,1\n",
      "66,1.52099,13.69,3.59,1.12,71.96,0.09,9.40,0.00,0.00,1\n",
      "67,1.52152,13.05,3.65,0.87,72.22,0.19,9.85,0.00,0.17,1\n",
      "68,1.52152,13.05,3.65,0.87,72.32,0.19,9.85,0.00,0.17,1\n",
      "69,1.52152,13.12,3.58,0.90,72.20,0.23,9.82,0.00,0.16,1\n",
      "70,1.52300,13.31,3.58,0.82,71.99,0.12,10.17,0.00,0.03,1\n",
      "71,1.51574,14.86,3.67,1.74,71.87,0.16,7.36,0.00,0.12,2\n",
      "72,1.51848,13.64,3.87,1.27,71.96,0.54,8.32,0.00,0.32,2\n",
      "73,1.51593,13.09,3.59,1.52,73.10,0.67,7.83,0.00,0.00,2\n",
      "74,1.51631,13.34,3.57,1.57,72.87,0.61,7.89,0.00,0.00,2\n",
      "75,1.51596,13.02,3.56,1.54,73.11,0.72,7.90,0.00,0.00,2\n",
      "76,1.51590,13.02,3.58,1.51,73.12,0.69,7.96,0.00,0.00,2\n",
      "77,1.51645,13.44,3.61,1.54,72.39,0.66,8.03,0.00,0.00,2\n",
      "78,1.51627,13.00,3.58,1.54,72.83,0.61,8.04,0.00,0.00,2\n",
      "79,1.51613,13.92,3.52,1.25,72.88,0.37,7.94,0.00,0.14,2\n",
      "80,1.51590,12.82,3.52,1.90,72.86,0.69,7.97,0.00,0.00,2\n",
      "81,1.51592,12.86,3.52,2.12,72.66,0.69,7.97,0.00,0.00,2\n",
      "82,1.51593,13.25,3.45,1.43,73.17,0.61,7.86,0.00,0.00,2\n",
      "83,1.51646,13.41,3.55,1.25,72.81,0.68,8.10,0.00,0.00,2\n",
      "84,1.51594,13.09,3.52,1.55,72.87,0.68,8.05,0.00,0.09,2\n",
      "85,1.51409,14.25,3.09,2.08,72.28,1.10,7.08,0.00,0.00,2\n",
      "86,1.51625,13.36,3.58,1.49,72.72,0.45,8.21,0.00,0.00,2\n",
      "87,1.51569,13.24,3.49,1.47,73.25,0.38,8.03,0.00,0.00,2\n",
      "88,1.51645,13.40,3.49,1.52,72.65,0.67,8.08,0.00,0.10,2\n",
      "89,1.51618,13.01,3.50,1.48,72.89,0.60,8.12,0.00,0.00,2\n",
      "90,1.51640,12.55,3.48,1.87,73.23,0.63,8.08,0.00,0.09,2\n",
      "91,1.51841,12.93,3.74,1.11,72.28,0.64,8.96,0.00,0.22,2\n",
      "92,1.51605,12.90,3.44,1.45,73.06,0.44,8.27,0.00,0.00,2\n",
      "93,1.51588,13.12,3.41,1.58,73.26,0.07,8.39,0.00,0.19,2\n",
      "94,1.51590,13.24,3.34,1.47,73.10,0.39,8.22,0.00,0.00,2\n",
      "95,1.51629,12.71,3.33,1.49,73.28,0.67,8.24,0.00,0.00,2\n",
      "96,1.51860,13.36,3.43,1.43,72.26,0.51,8.60,0.00,0.00,2\n",
      "97,1.51841,13.02,3.62,1.06,72.34,0.64,9.13,0.00,0.15,2\n",
      "98,1.51743,12.20,3.25,1.16,73.55,0.62,8.90,0.00,0.24,2\n",
      "99,1.51689,12.67,2.88,1.71,73.21,0.73,8.54,0.00,0.00,2\n",
      "100,1.51811,12.96,2.96,1.43,72.92,0.60,8.79,0.14,0.00,2\n",
      "101,1.51655,12.75,2.85,1.44,73.27,0.57,8.79,0.11,0.22,2\n",
      "102,1.51730,12.35,2.72,1.63,72.87,0.70,9.23,0.00,0.00,2\n",
      "103,1.51820,12.62,2.76,0.83,73.81,0.35,9.42,0.00,0.20,2\n",
      "104,1.52725,13.80,3.15,0.66,70.57,0.08,11.64,0.00,0.00,2\n",
      "105,1.52410,13.83,2.90,1.17,71.15,0.08,10.79,0.00,0.00,2\n",
      "106,1.52475,11.45,0.00,1.88,72.19,0.81,13.24,0.00,0.34,2\n",
      "107,1.53125,10.73,0.00,2.10,69.81,0.58,13.30,3.15,0.28,2\n",
      "108,1.53393,12.30,0.00,1.00,70.16,0.12,16.19,0.00,0.24,2\n",
      "109,1.52222,14.43,0.00,1.00,72.67,0.10,11.52,0.00,0.08,2\n",
      "110,1.51818,13.72,0.00,0.56,74.45,0.00,10.99,0.00,0.00,2\n",
      "111,1.52664,11.23,0.00,0.77,73.21,0.00,14.68,0.00,0.00,2\n",
      "112,1.52739,11.02,0.00,0.75,73.08,0.00,14.96,0.00,0.00,2\n",
      "113,1.52777,12.64,0.00,0.67,72.02,0.06,14.40,0.00,0.00,2\n",
      "114,1.51892,13.46,3.83,1.26,72.55,0.57,8.21,0.00,0.14,2\n",
      "115,1.51847,13.10,3.97,1.19,72.44,0.60,8.43,0.00,0.00,2\n",
      "116,1.51846,13.41,3.89,1.33,72.38,0.51,8.28,0.00,0.00,2\n",
      "117,1.51829,13.24,3.90,1.41,72.33,0.55,8.31,0.00,0.10,2\n",
      "118,1.51708,13.72,3.68,1.81,72.06,0.64,7.88,0.00,0.00,2\n",
      "119,1.51673,13.30,3.64,1.53,72.53,0.65,8.03,0.00,0.29,2\n",
      "120,1.51652,13.56,3.57,1.47,72.45,0.64,7.96,0.00,0.00,2\n",
      "121,1.51844,13.25,3.76,1.32,72.40,0.58,8.42,0.00,0.00,2\n",
      "122,1.51663,12.93,3.54,1.62,72.96,0.64,8.03,0.00,0.21,2\n",
      "123,1.51687,13.23,3.54,1.48,72.84,0.56,8.10,0.00,0.00,2\n",
      "124,1.51707,13.48,3.48,1.71,72.52,0.62,7.99,0.00,0.00,2\n",
      "125,1.52177,13.20,3.68,1.15,72.75,0.54,8.52,0.00,0.00,2\n",
      "126,1.51872,12.93,3.66,1.56,72.51,0.58,8.55,0.00,0.12,2\n",
      "127,1.51667,12.94,3.61,1.26,72.75,0.56,8.60,0.00,0.00,2\n",
      "128,1.52081,13.78,2.28,1.43,71.99,0.49,9.85,0.00,0.17,2\n",
      "129,1.52068,13.55,2.09,1.67,72.18,0.53,9.57,0.27,0.17,2\n",
      "130,1.52020,13.98,1.35,1.63,71.76,0.39,10.56,0.00,0.18,2\n",
      "131,1.52177,13.75,1.01,1.36,72.19,0.33,11.14,0.00,0.00,2\n",
      "132,1.52614,13.70,0.00,1.36,71.24,0.19,13.44,0.00,0.10,2\n",
      "133,1.51813,13.43,3.98,1.18,72.49,0.58,8.15,0.00,0.00,2\n",
      "134,1.51800,13.71,3.93,1.54,71.81,0.54,8.21,0.00,0.15,2\n",
      "135,1.51811,13.33,3.85,1.25,72.78,0.52,8.12,0.00,0.00,2\n",
      "136,1.51789,13.19,3.90,1.30,72.33,0.55,8.44,0.00,0.28,2\n",
      "137,1.51806,13.00,3.80,1.08,73.07,0.56,8.38,0.00,0.12,2\n",
      "138,1.51711,12.89,3.62,1.57,72.96,0.61,8.11,0.00,0.00,2\n",
      "139,1.51674,12.79,3.52,1.54,73.36,0.66,7.90,0.00,0.00,2\n",
      "140,1.51674,12.87,3.56,1.64,73.14,0.65,7.99,0.00,0.00,2\n",
      "141,1.51690,13.33,3.54,1.61,72.54,0.68,8.11,0.00,0.00,2\n",
      "142,1.51851,13.20,3.63,1.07,72.83,0.57,8.41,0.09,0.17,2\n",
      "143,1.51662,12.85,3.51,1.44,73.01,0.68,8.23,0.06,0.25,2\n",
      "144,1.51709,13.00,3.47,1.79,72.72,0.66,8.18,0.00,0.00,2\n",
      "145,1.51660,12.99,3.18,1.23,72.97,0.58,8.81,0.00,0.24,2\n",
      "146,1.51839,12.85,3.67,1.24,72.57,0.62,8.68,0.00,0.35,2\n",
      "147,1.51769,13.65,3.66,1.11,72.77,0.11,8.60,0.00,0.00,3\n",
      "148,1.51610,13.33,3.53,1.34,72.67,0.56,8.33,0.00,0.00,3\n",
      "149,1.51670,13.24,3.57,1.38,72.70,0.56,8.44,0.00,0.10,3\n",
      "150,1.51643,12.16,3.52,1.35,72.89,0.57,8.53,0.00,0.00,3\n",
      "151,1.51665,13.14,3.45,1.76,72.48,0.60,8.38,0.00,0.17,3\n",
      "152,1.52127,14.32,3.90,0.83,71.50,0.00,9.49,0.00,0.00,3\n",
      "153,1.51779,13.64,3.65,0.65,73.00,0.06,8.93,0.00,0.00,3\n",
      "154,1.51610,13.42,3.40,1.22,72.69,0.59,8.32,0.00,0.00,3\n",
      "155,1.51694,12.86,3.58,1.31,72.61,0.61,8.79,0.00,0.00,3\n",
      "156,1.51646,13.04,3.40,1.26,73.01,0.52,8.58,0.00,0.00,3\n",
      "157,1.51655,13.41,3.39,1.28,72.64,0.52,8.65,0.00,0.00,3\n",
      "158,1.52121,14.03,3.76,0.58,71.79,0.11,9.65,0.00,0.00,3\n",
      "159,1.51776,13.53,3.41,1.52,72.04,0.58,8.79,0.00,0.00,3\n",
      "160,1.51796,13.50,3.36,1.63,71.94,0.57,8.81,0.00,0.09,3\n",
      "161,1.51832,13.33,3.34,1.54,72.14,0.56,8.99,0.00,0.00,3\n",
      "162,1.51934,13.64,3.54,0.75,72.65,0.16,8.89,0.15,0.24,3\n",
      "163,1.52211,14.19,3.78,0.91,71.36,0.23,9.14,0.00,0.37,3\n",
      "164,1.51514,14.01,2.68,3.50,69.89,1.68,5.87,2.20,0.00,5\n",
      "165,1.51915,12.73,1.85,1.86,72.69,0.60,10.09,0.00,0.00,5\n",
      "166,1.52171,11.56,1.88,1.56,72.86,0.47,11.41,0.00,0.00,5\n",
      "167,1.52151,11.03,1.71,1.56,73.44,0.58,11.62,0.00,0.00,5\n",
      "168,1.51969,12.64,0.00,1.65,73.75,0.38,11.53,0.00,0.00,5\n",
      "169,1.51666,12.86,0.00,1.83,73.88,0.97,10.17,0.00,0.00,5\n",
      "170,1.51994,13.27,0.00,1.76,73.03,0.47,11.32,0.00,0.00,5\n",
      "171,1.52369,13.44,0.00,1.58,72.22,0.32,12.24,0.00,0.00,5\n",
      "172,1.51316,13.02,0.00,3.04,70.48,6.21,6.96,0.00,0.00,5\n",
      "173,1.51321,13.00,0.00,3.02,70.70,6.21,6.93,0.00,0.00,5\n",
      "174,1.52043,13.38,0.00,1.40,72.25,0.33,12.50,0.00,0.00,5\n",
      "175,1.52058,12.85,1.61,2.17,72.18,0.76,9.70,0.24,0.51,5\n",
      "176,1.52119,12.97,0.33,1.51,73.39,0.13,11.27,0.00,0.28,5\n",
      "177,1.51905,14.00,2.39,1.56,72.37,0.00,9.57,0.00,0.00,6\n",
      "178,1.51937,13.79,2.41,1.19,72.76,0.00,9.77,0.00,0.00,6\n",
      "179,1.51829,14.46,2.24,1.62,72.38,0.00,9.26,0.00,0.00,6\n",
      "180,1.51852,14.09,2.19,1.66,72.67,0.00,9.32,0.00,0.00,6\n",
      "181,1.51299,14.40,1.74,1.54,74.55,0.00,7.59,0.00,0.00,6\n",
      "182,1.51888,14.99,0.78,1.74,72.50,0.00,9.95,0.00,0.00,6\n",
      "183,1.51916,14.15,0.00,2.09,72.74,0.00,10.88,0.00,0.00,6\n",
      "184,1.51969,14.56,0.00,0.56,73.48,0.00,11.22,0.00,0.00,6\n",
      "185,1.51115,17.38,0.00,0.34,75.41,0.00,6.65,0.00,0.00,6\n",
      "186,1.51131,13.69,3.20,1.81,72.81,1.76,5.43,1.19,0.00,7\n",
      "187,1.51838,14.32,3.26,2.22,71.25,1.46,5.79,1.63,0.00,7\n",
      "188,1.52315,13.44,3.34,1.23,72.38,0.60,8.83,0.00,0.00,7\n",
      "189,1.52247,14.86,2.20,2.06,70.26,0.76,9.76,0.00,0.00,7\n",
      "190,1.52365,15.79,1.83,1.31,70.43,0.31,8.61,1.68,0.00,7\n",
      "191,1.51613,13.88,1.78,1.79,73.10,0.00,8.67,0.76,0.00,7\n",
      "192,1.51602,14.85,0.00,2.38,73.28,0.00,8.76,0.64,0.09,7\n",
      "193,1.51623,14.20,0.00,2.79,73.46,0.04,9.04,0.40,0.09,7\n",
      "194,1.51719,14.75,0.00,2.00,73.02,0.00,8.53,1.59,0.08,7\n",
      "195,1.51683,14.56,0.00,1.98,73.29,0.00,8.52,1.57,0.07,7\n",
      "196,1.51545,14.14,0.00,2.68,73.39,0.08,9.07,0.61,0.05,7\n",
      "197,1.51556,13.87,0.00,2.54,73.23,0.14,9.41,0.81,0.01,7\n",
      "198,1.51727,14.70,0.00,2.34,73.28,0.00,8.95,0.66,0.00,7\n",
      "199,1.51531,14.38,0.00,2.66,73.10,0.04,9.08,0.64,0.00,7\n",
      "200,1.51609,15.01,0.00,2.51,73.05,0.05,8.83,0.53,0.00,7\n",
      "201,1.51508,15.15,0.00,2.25,73.50,0.00,8.34,0.63,0.00,7\n",
      "202,1.51653,11.95,0.00,1.19,75.18,2.70,8.93,0.00,0.00,7\n",
      "203,1.51514,14.85,0.00,2.42,73.72,0.00,8.39,0.56,0.00,7\n",
      "204,1.51658,14.80,0.00,1.99,73.11,0.00,8.28,1.71,0.00,7\n",
      "205,1.51617,14.95,0.00,2.27,73.30,0.00,8.71,0.67,0.00,7\n",
      "206,1.51732,14.95,0.00,1.80,72.99,0.00,8.61,1.55,0.00,7\n",
      "207,1.51645,14.94,0.00,1.87,73.11,0.00,8.67,1.38,0.00,7\n",
      "208,1.51831,14.39,0.00,1.82,72.86,1.41,6.47,2.88,0.00,7\n",
      "209,1.51640,14.37,0.00,2.74,72.85,0.00,9.45,0.54,0.00,7\n",
      "210,1.51623,14.14,0.00,2.88,72.61,0.08,9.18,1.06,0.00,7\n",
      "211,1.51685,14.92,0.00,1.99,73.06,0.00,8.40,1.59,0.00,7\n",
      "212,1.52065,14.36,0.00,2.02,73.42,0.00,8.44,1.64,0.00,7\n",
      "213,1.51651,14.38,0.00,1.94,73.61,0.00,8.48,1.57,0.00,7\n",
      "214,1.51711,14.23,0.00,2.08,73.36,0.00,8.62,1.67,0.00,7\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "with open('024.glass.data' , 'r') as f :\n",
    "    glass_data = csv.reader(f , delimiter = '\\n')\n",
    "    for i in glass_data:\n",
    "        print(i[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "ename": "ProgrammingError",
     "evalue": "1050 (42S01): Table 'glassdata' already exists",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mMySQLInterfaceError\u001b[0m                       Traceback (most recent call last)",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\connection_cext.py:535\u001b[0m, in \u001b[0;36mCMySQLConnection.cmd_query\u001b[1;34m(self, query, raw, buffered, raw_as_string)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=533'>534</a>\u001b[0m         query \u001b[39m=\u001b[39m query\u001b[39m.\u001b[39mencode(\u001b[39m'\u001b[39m\u001b[39mutf-8\u001b[39m\u001b[39m'\u001b[39m)\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=534'>535</a>\u001b[0m     \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_cmysql\u001b[39m.\u001b[39;49mquery(query,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=535'>536</a>\u001b[0m                        raw\u001b[39m=\u001b[39;49mraw, buffered\u001b[39m=\u001b[39;49mbuffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=536'>537</a>\u001b[0m                        raw_as_string\u001b[39m=\u001b[39;49mraw_as_string,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=537'>538</a>\u001b[0m                        query_attrs\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_query_attrs)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=538'>539</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n",
      "\u001b[1;31mMySQLInterfaceError\u001b[0m: Table 'glassdata' already exists",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mProgrammingError\u001b[0m                          Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\nayak\\Desktop\\SelfProject\\iNeuron\\Python\\025.SQL basic.ipynb Cell 27'\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> <a href='vscode-notebook-cell:/c%3A/Users/nayak/Desktop/SelfProject/iNeuron/Python/025.SQL%20basic.ipynb#ch0000026?line=0'>1</a>\u001b[0m cursor\u001b[39m.\u001b[39;49mexecute(\u001b[39m'\u001b[39;49m\u001b[39mcreate table testineuron.glassdata(col1 INT(10) ,col2 float(10,5),col3 float(10,5) ,col4 float(10,5) , col5 float(10,5),col6 float(10,5) ,clo7 float(10,5) , col8 float(10,5) , col9 float(10,5) , col10 float(10,5) , col11 INT(10)) \u001b[39;49m\u001b[39m'\u001b[39;49m)\n",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\cursor_cext.py:269\u001b[0m, in \u001b[0;36mCMySQLCursor.execute\u001b[1;34m(self, operation, params, multi)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=264'>265</a>\u001b[0m             \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mProgrammingError(\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=265'>266</a>\u001b[0m                 \u001b[39m\"\u001b[39m\u001b[39mNot all parameters were used in the SQL statement\u001b[39m\u001b[39m\"\u001b[39m)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=267'>268</a>\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=268'>269</a>\u001b[0m     result \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_cnx\u001b[39m.\u001b[39;49mcmd_query(stmt, raw\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_raw,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=269'>270</a>\u001b[0m                                  buffered\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_buffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=270'>271</a>\u001b[0m                                  raw_as_string\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_raw_as_string)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=271'>272</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=272'>273</a>\u001b[0m     \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mget_mysql_exception(msg\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39mmsg, errno\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39merrno,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/cursor_cext.py?line=273'>274</a>\u001b[0m                                      sqlstate\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39msqlstate)\n",
      "File \u001b[1;32mc:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\mysql\\connector\\connection_cext.py:540\u001b[0m, in \u001b[0;36mCMySQLConnection.cmd_query\u001b[1;34m(self, query, raw, buffered, raw_as_string)\u001b[0m\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=534'>535</a>\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_cmysql\u001b[39m.\u001b[39mquery(query,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=535'>536</a>\u001b[0m                        raw\u001b[39m=\u001b[39mraw, buffered\u001b[39m=\u001b[39mbuffered,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=536'>537</a>\u001b[0m                        raw_as_string\u001b[39m=\u001b[39mraw_as_string,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=537'>538</a>\u001b[0m                        query_attrs\u001b[39m=\u001b[39m\u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_query_attrs)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=538'>539</a>\u001b[0m \u001b[39mexcept\u001b[39;00m MySQLInterfaceError \u001b[39mas\u001b[39;00m exc:\n\u001b[1;32m--> <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=539'>540</a>\u001b[0m     \u001b[39mraise\u001b[39;00m errors\u001b[39m.\u001b[39mget_mysql_exception(exc\u001b[39m.\u001b[39merrno, msg\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39mmsg,\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=540'>541</a>\u001b[0m                                      sqlstate\u001b[39m=\u001b[39mexc\u001b[39m.\u001b[39msqlstate)\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=541'>542</a>\u001b[0m \u001b[39mexcept\u001b[39;00m \u001b[39mAttributeError\u001b[39;00m:\n\u001b[0;32m    <a href='file:///c%3A/Users/nayak/AppData/Local/Programs/Python/Python310/lib/site-packages/mysql/connector/connection_cext.py?line=542'>543</a>\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_unix_socket:\n",
      "\u001b[1;31mProgrammingError\u001b[0m: 1050 (42S01): Table 'glassdata' already exists"
     ]
    }
   ],
   "source": [
    "cursor.execute('create table testineuron.glassdata(col1 INT(10) ,col2 float(10,5),col3 float(10,5) ,col4 float(10,5) , col5 float(10,5),col6 float(10,5) ,clo7 float(10,5) , col8 float(10,5) , col9 float(10,5) , col10 float(10,5) , col11 INT(10)) ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('insert into testineuron.glassdata values(1,1.52101,13.64,4.49,1.10,71.78,0.06,8.75,0.00,0.00,1)')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "mydb.commit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor.execute('select * from testineuron.glassdata')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1, 1.52101, 13.64, 4.49, 1.1, 71.78, 0.06, 8.75, 0.0, 0.0, 1)]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'str'>\n",
      "insert into glassdata values (1,1.52101,13.64,4.49,1.10,71.78,0.06,8.75,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (2,1.51761,13.89,3.60,1.36,72.73,0.48,7.83,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (3,1.51618,13.53,3.55,1.54,72.99,0.39,7.78,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (4,1.51766,13.21,3.69,1.29,72.61,0.57,8.22,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (5,1.51742,13.27,3.62,1.24,73.08,0.55,8.07,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (6,1.51596,12.79,3.61,1.62,72.97,0.64,8.07,0.00,0.26,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (7,1.51743,13.30,3.60,1.14,73.09,0.58,8.17,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (8,1.51756,13.15,3.61,1.05,73.24,0.57,8.24,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (9,1.51918,14.04,3.58,1.37,72.08,0.56,8.30,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (10,1.51755,13.00,3.60,1.36,72.99,0.57,8.40,0.00,0.11,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (11,1.51571,12.72,3.46,1.56,73.20,0.67,8.09,0.00,0.24,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (12,1.51763,12.80,3.66,1.27,73.01,0.60,8.56,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (13,1.51589,12.88,3.43,1.40,73.28,0.69,8.05,0.00,0.24,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (14,1.51748,12.86,3.56,1.27,73.21,0.54,8.38,0.00,0.17,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (15,1.51763,12.61,3.59,1.31,73.29,0.58,8.50,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (16,1.51761,12.81,3.54,1.23,73.24,0.58,8.39,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (17,1.51784,12.68,3.67,1.16,73.11,0.61,8.70,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (18,1.52196,14.36,3.85,0.89,71.36,0.15,9.15,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (19,1.51911,13.90,3.73,1.18,72.12,0.06,8.89,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (20,1.51735,13.02,3.54,1.69,72.73,0.54,8.44,0.00,0.07,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (21,1.51750,12.82,3.55,1.49,72.75,0.54,8.52,0.00,0.19,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (22,1.51966,14.77,3.75,0.29,72.02,0.03,9.00,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (23,1.51736,12.78,3.62,1.29,72.79,0.59,8.70,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (24,1.51751,12.81,3.57,1.35,73.02,0.62,8.59,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (25,1.51720,13.38,3.50,1.15,72.85,0.50,8.43,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (26,1.51764,12.98,3.54,1.21,73.00,0.65,8.53,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (27,1.51793,13.21,3.48,1.41,72.64,0.59,8.43,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (28,1.51721,12.87,3.48,1.33,73.04,0.56,8.43,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (29,1.51768,12.56,3.52,1.43,73.15,0.57,8.54,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (30,1.51784,13.08,3.49,1.28,72.86,0.60,8.49,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (31,1.51768,12.65,3.56,1.30,73.08,0.61,8.69,0.00,0.14,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (32,1.51747,12.84,3.50,1.14,73.27,0.56,8.55,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (33,1.51775,12.85,3.48,1.23,72.97,0.61,8.56,0.09,0.22,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (34,1.51753,12.57,3.47,1.38,73.39,0.60,8.55,0.00,0.06,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (35,1.51783,12.69,3.54,1.34,72.95,0.57,8.75,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (36,1.51567,13.29,3.45,1.21,72.74,0.56,8.57,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (37,1.51909,13.89,3.53,1.32,71.81,0.51,8.78,0.11,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (38,1.51797,12.74,3.48,1.35,72.96,0.64,8.68,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (39,1.52213,14.21,3.82,0.47,71.77,0.11,9.57,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (40,1.52213,14.21,3.82,0.47,71.77,0.11,9.57,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (41,1.51793,12.79,3.50,1.12,73.03,0.64,8.77,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (42,1.51755,12.71,3.42,1.20,73.20,0.59,8.64,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (43,1.51779,13.21,3.39,1.33,72.76,0.59,8.59,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (44,1.52210,13.73,3.84,0.72,71.76,0.17,9.74,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (45,1.51786,12.73,3.43,1.19,72.95,0.62,8.76,0.00,0.30,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (46,1.51900,13.49,3.48,1.35,71.95,0.55,9.00,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (47,1.51869,13.19,3.37,1.18,72.72,0.57,8.83,0.00,0.16,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (48,1.52667,13.99,3.70,0.71,71.57,0.02,9.82,0.00,0.10,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (49,1.52223,13.21,3.77,0.79,71.99,0.13,10.02,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (50,1.51898,13.58,3.35,1.23,72.08,0.59,8.91,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (51,1.52320,13.72,3.72,0.51,71.75,0.09,10.06,0.00,0.16,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (52,1.51926,13.20,3.33,1.28,72.36,0.60,9.14,0.00,0.11,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (53,1.51808,13.43,2.87,1.19,72.84,0.55,9.03,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (54,1.51837,13.14,2.84,1.28,72.85,0.55,9.07,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (55,1.51778,13.21,2.81,1.29,72.98,0.51,9.02,0.00,0.09,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (56,1.51769,12.45,2.71,1.29,73.70,0.56,9.06,0.00,0.24,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (57,1.51215,12.99,3.47,1.12,72.98,0.62,8.35,0.00,0.31,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (58,1.51824,12.87,3.48,1.29,72.95,0.60,8.43,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (59,1.51754,13.48,3.74,1.17,72.99,0.59,8.03,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (60,1.51754,13.39,3.66,1.19,72.79,0.57,8.27,0.00,0.11,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (61,1.51905,13.60,3.62,1.11,72.64,0.14,8.76,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (62,1.51977,13.81,3.58,1.32,71.72,0.12,8.67,0.69,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (63,1.52172,13.51,3.86,0.88,71.79,0.23,9.54,0.00,0.11,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (64,1.52227,14.17,3.81,0.78,71.35,0.00,9.69,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (65,1.52172,13.48,3.74,0.90,72.01,0.18,9.61,0.00,0.07,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (66,1.52099,13.69,3.59,1.12,71.96,0.09,9.40,0.00,0.00,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (67,1.52152,13.05,3.65,0.87,72.22,0.19,9.85,0.00,0.17,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (68,1.52152,13.05,3.65,0.87,72.32,0.19,9.85,0.00,0.17,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (69,1.52152,13.12,3.58,0.90,72.20,0.23,9.82,0.00,0.16,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (70,1.52300,13.31,3.58,0.82,71.99,0.12,10.17,0.00,0.03,1)\n",
      "<class 'str'>\n",
      "insert into glassdata values (71,1.51574,14.86,3.67,1.74,71.87,0.16,7.36,0.00,0.12,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (72,1.51848,13.64,3.87,1.27,71.96,0.54,8.32,0.00,0.32,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (73,1.51593,13.09,3.59,1.52,73.10,0.67,7.83,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (74,1.51631,13.34,3.57,1.57,72.87,0.61,7.89,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (75,1.51596,13.02,3.56,1.54,73.11,0.72,7.90,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (76,1.51590,13.02,3.58,1.51,73.12,0.69,7.96,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (77,1.51645,13.44,3.61,1.54,72.39,0.66,8.03,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (78,1.51627,13.00,3.58,1.54,72.83,0.61,8.04,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (79,1.51613,13.92,3.52,1.25,72.88,0.37,7.94,0.00,0.14,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (80,1.51590,12.82,3.52,1.90,72.86,0.69,7.97,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (81,1.51592,12.86,3.52,2.12,72.66,0.69,7.97,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (82,1.51593,13.25,3.45,1.43,73.17,0.61,7.86,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (83,1.51646,13.41,3.55,1.25,72.81,0.68,8.10,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (84,1.51594,13.09,3.52,1.55,72.87,0.68,8.05,0.00,0.09,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (85,1.51409,14.25,3.09,2.08,72.28,1.10,7.08,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (86,1.51625,13.36,3.58,1.49,72.72,0.45,8.21,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (87,1.51569,13.24,3.49,1.47,73.25,0.38,8.03,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (88,1.51645,13.40,3.49,1.52,72.65,0.67,8.08,0.00,0.10,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (89,1.51618,13.01,3.50,1.48,72.89,0.60,8.12,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (90,1.51640,12.55,3.48,1.87,73.23,0.63,8.08,0.00,0.09,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (91,1.51841,12.93,3.74,1.11,72.28,0.64,8.96,0.00,0.22,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (92,1.51605,12.90,3.44,1.45,73.06,0.44,8.27,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (93,1.51588,13.12,3.41,1.58,73.26,0.07,8.39,0.00,0.19,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (94,1.51590,13.24,3.34,1.47,73.10,0.39,8.22,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (95,1.51629,12.71,3.33,1.49,73.28,0.67,8.24,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (96,1.51860,13.36,3.43,1.43,72.26,0.51,8.60,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (97,1.51841,13.02,3.62,1.06,72.34,0.64,9.13,0.00,0.15,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (98,1.51743,12.20,3.25,1.16,73.55,0.62,8.90,0.00,0.24,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (99,1.51689,12.67,2.88,1.71,73.21,0.73,8.54,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (100,1.51811,12.96,2.96,1.43,72.92,0.60,8.79,0.14,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (101,1.51655,12.75,2.85,1.44,73.27,0.57,8.79,0.11,0.22,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (102,1.51730,12.35,2.72,1.63,72.87,0.70,9.23,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (103,1.51820,12.62,2.76,0.83,73.81,0.35,9.42,0.00,0.20,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (104,1.52725,13.80,3.15,0.66,70.57,0.08,11.64,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (105,1.52410,13.83,2.90,1.17,71.15,0.08,10.79,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (106,1.52475,11.45,0.00,1.88,72.19,0.81,13.24,0.00,0.34,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (107,1.53125,10.73,0.00,2.10,69.81,0.58,13.30,3.15,0.28,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (108,1.53393,12.30,0.00,1.00,70.16,0.12,16.19,0.00,0.24,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (109,1.52222,14.43,0.00,1.00,72.67,0.10,11.52,0.00,0.08,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (110,1.51818,13.72,0.00,0.56,74.45,0.00,10.99,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (111,1.52664,11.23,0.00,0.77,73.21,0.00,14.68,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (112,1.52739,11.02,0.00,0.75,73.08,0.00,14.96,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (113,1.52777,12.64,0.00,0.67,72.02,0.06,14.40,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (114,1.51892,13.46,3.83,1.26,72.55,0.57,8.21,0.00,0.14,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (115,1.51847,13.10,3.97,1.19,72.44,0.60,8.43,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (116,1.51846,13.41,3.89,1.33,72.38,0.51,8.28,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (117,1.51829,13.24,3.90,1.41,72.33,0.55,8.31,0.00,0.10,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (118,1.51708,13.72,3.68,1.81,72.06,0.64,7.88,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (119,1.51673,13.30,3.64,1.53,72.53,0.65,8.03,0.00,0.29,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (120,1.51652,13.56,3.57,1.47,72.45,0.64,7.96,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (121,1.51844,13.25,3.76,1.32,72.40,0.58,8.42,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (122,1.51663,12.93,3.54,1.62,72.96,0.64,8.03,0.00,0.21,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (123,1.51687,13.23,3.54,1.48,72.84,0.56,8.10,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (124,1.51707,13.48,3.48,1.71,72.52,0.62,7.99,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (125,1.52177,13.20,3.68,1.15,72.75,0.54,8.52,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (126,1.51872,12.93,3.66,1.56,72.51,0.58,8.55,0.00,0.12,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (127,1.51667,12.94,3.61,1.26,72.75,0.56,8.60,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (128,1.52081,13.78,2.28,1.43,71.99,0.49,9.85,0.00,0.17,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (129,1.52068,13.55,2.09,1.67,72.18,0.53,9.57,0.27,0.17,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (130,1.52020,13.98,1.35,1.63,71.76,0.39,10.56,0.00,0.18,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (131,1.52177,13.75,1.01,1.36,72.19,0.33,11.14,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (132,1.52614,13.70,0.00,1.36,71.24,0.19,13.44,0.00,0.10,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (133,1.51813,13.43,3.98,1.18,72.49,0.58,8.15,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (134,1.51800,13.71,3.93,1.54,71.81,0.54,8.21,0.00,0.15,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (135,1.51811,13.33,3.85,1.25,72.78,0.52,8.12,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (136,1.51789,13.19,3.90,1.30,72.33,0.55,8.44,0.00,0.28,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (137,1.51806,13.00,3.80,1.08,73.07,0.56,8.38,0.00,0.12,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (138,1.51711,12.89,3.62,1.57,72.96,0.61,8.11,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (139,1.51674,12.79,3.52,1.54,73.36,0.66,7.90,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (140,1.51674,12.87,3.56,1.64,73.14,0.65,7.99,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (141,1.51690,13.33,3.54,1.61,72.54,0.68,8.11,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (142,1.51851,13.20,3.63,1.07,72.83,0.57,8.41,0.09,0.17,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (143,1.51662,12.85,3.51,1.44,73.01,0.68,8.23,0.06,0.25,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (144,1.51709,13.00,3.47,1.79,72.72,0.66,8.18,0.00,0.00,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (145,1.51660,12.99,3.18,1.23,72.97,0.58,8.81,0.00,0.24,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (146,1.51839,12.85,3.67,1.24,72.57,0.62,8.68,0.00,0.35,2)\n",
      "<class 'str'>\n",
      "insert into glassdata values (147,1.51769,13.65,3.66,1.11,72.77,0.11,8.60,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (148,1.51610,13.33,3.53,1.34,72.67,0.56,8.33,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (149,1.51670,13.24,3.57,1.38,72.70,0.56,8.44,0.00,0.10,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (150,1.51643,12.16,3.52,1.35,72.89,0.57,8.53,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (151,1.51665,13.14,3.45,1.76,72.48,0.60,8.38,0.00,0.17,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (152,1.52127,14.32,3.90,0.83,71.50,0.00,9.49,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (153,1.51779,13.64,3.65,0.65,73.00,0.06,8.93,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (154,1.51610,13.42,3.40,1.22,72.69,0.59,8.32,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (155,1.51694,12.86,3.58,1.31,72.61,0.61,8.79,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (156,1.51646,13.04,3.40,1.26,73.01,0.52,8.58,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (157,1.51655,13.41,3.39,1.28,72.64,0.52,8.65,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (158,1.52121,14.03,3.76,0.58,71.79,0.11,9.65,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (159,1.51776,13.53,3.41,1.52,72.04,0.58,8.79,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (160,1.51796,13.50,3.36,1.63,71.94,0.57,8.81,0.00,0.09,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (161,1.51832,13.33,3.34,1.54,72.14,0.56,8.99,0.00,0.00,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (162,1.51934,13.64,3.54,0.75,72.65,0.16,8.89,0.15,0.24,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (163,1.52211,14.19,3.78,0.91,71.36,0.23,9.14,0.00,0.37,3)\n",
      "<class 'str'>\n",
      "insert into glassdata values (164,1.51514,14.01,2.68,3.50,69.89,1.68,5.87,2.20,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (165,1.51915,12.73,1.85,1.86,72.69,0.60,10.09,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (166,1.52171,11.56,1.88,1.56,72.86,0.47,11.41,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (167,1.52151,11.03,1.71,1.56,73.44,0.58,11.62,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (168,1.51969,12.64,0.00,1.65,73.75,0.38,11.53,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (169,1.51666,12.86,0.00,1.83,73.88,0.97,10.17,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (170,1.51994,13.27,0.00,1.76,73.03,0.47,11.32,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (171,1.52369,13.44,0.00,1.58,72.22,0.32,12.24,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (172,1.51316,13.02,0.00,3.04,70.48,6.21,6.96,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (173,1.51321,13.00,0.00,3.02,70.70,6.21,6.93,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (174,1.52043,13.38,0.00,1.40,72.25,0.33,12.50,0.00,0.00,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (175,1.52058,12.85,1.61,2.17,72.18,0.76,9.70,0.24,0.51,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (176,1.52119,12.97,0.33,1.51,73.39,0.13,11.27,0.00,0.28,5)\n",
      "<class 'str'>\n",
      "insert into glassdata values (177,1.51905,14.00,2.39,1.56,72.37,0.00,9.57,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (178,1.51937,13.79,2.41,1.19,72.76,0.00,9.77,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (179,1.51829,14.46,2.24,1.62,72.38,0.00,9.26,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (180,1.51852,14.09,2.19,1.66,72.67,0.00,9.32,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (181,1.51299,14.40,1.74,1.54,74.55,0.00,7.59,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (182,1.51888,14.99,0.78,1.74,72.50,0.00,9.95,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (183,1.51916,14.15,0.00,2.09,72.74,0.00,10.88,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (184,1.51969,14.56,0.00,0.56,73.48,0.00,11.22,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (185,1.51115,17.38,0.00,0.34,75.41,0.00,6.65,0.00,0.00,6)\n",
      "<class 'str'>\n",
      "insert into glassdata values (186,1.51131,13.69,3.20,1.81,72.81,1.76,5.43,1.19,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (187,1.51838,14.32,3.26,2.22,71.25,1.46,5.79,1.63,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (188,1.52315,13.44,3.34,1.23,72.38,0.60,8.83,0.00,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (189,1.52247,14.86,2.20,2.06,70.26,0.76,9.76,0.00,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (190,1.52365,15.79,1.83,1.31,70.43,0.31,8.61,1.68,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (191,1.51613,13.88,1.78,1.79,73.10,0.00,8.67,0.76,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (192,1.51602,14.85,0.00,2.38,73.28,0.00,8.76,0.64,0.09,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (193,1.51623,14.20,0.00,2.79,73.46,0.04,9.04,0.40,0.09,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (194,1.51719,14.75,0.00,2.00,73.02,0.00,8.53,1.59,0.08,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (195,1.51683,14.56,0.00,1.98,73.29,0.00,8.52,1.57,0.07,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (196,1.51545,14.14,0.00,2.68,73.39,0.08,9.07,0.61,0.05,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (197,1.51556,13.87,0.00,2.54,73.23,0.14,9.41,0.81,0.01,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (198,1.51727,14.70,0.00,2.34,73.28,0.00,8.95,0.66,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (199,1.51531,14.38,0.00,2.66,73.10,0.04,9.08,0.64,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (200,1.51609,15.01,0.00,2.51,73.05,0.05,8.83,0.53,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (201,1.51508,15.15,0.00,2.25,73.50,0.00,8.34,0.63,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (202,1.51653,11.95,0.00,1.19,75.18,2.70,8.93,0.00,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (203,1.51514,14.85,0.00,2.42,73.72,0.00,8.39,0.56,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (204,1.51658,14.80,0.00,1.99,73.11,0.00,8.28,1.71,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (205,1.51617,14.95,0.00,2.27,73.30,0.00,8.71,0.67,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (206,1.51732,14.95,0.00,1.80,72.99,0.00,8.61,1.55,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (207,1.51645,14.94,0.00,1.87,73.11,0.00,8.67,1.38,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (208,1.51831,14.39,0.00,1.82,72.86,1.41,6.47,2.88,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (209,1.51640,14.37,0.00,2.74,72.85,0.00,9.45,0.54,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (210,1.51623,14.14,0.00,2.88,72.61,0.08,9.18,1.06,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (211,1.51685,14.92,0.00,1.99,73.06,0.00,8.40,1.59,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (212,1.52065,14.36,0.00,2.02,73.42,0.00,8.44,1.64,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (213,1.51651,14.38,0.00,1.94,73.61,0.00,8.48,1.57,0.00,7)\n",
      "<class 'str'>\n",
      "insert into glassdata values (214,1.51711,14.23,0.00,2.08,73.36,0.00,8.62,1.67,0.00,7)\n"
     ]
    }
   ],
   "source": [
    "with open('024.glass.data','r') as f:\n",
    "    glass_data=csv.reader(f,delimiter='\\n')\n",
    "    for i in glass_data:\n",
    "        print(type(i[0]))\n",
    "        print(f'insert into glassdata values ({str(i[0])})')\n",
    "        cursor.execute('insert into testineuron.glassdata values({values})'.format(values = ((i[0]))))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "mydb.commit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>col1</th>\n",
       "      <th>col2</th>\n",
       "      <th>col3</th>\n",
       "      <th>col4</th>\n",
       "      <th>col5</th>\n",
       "      <th>col6</th>\n",
       "      <th>clo7</th>\n",
       "      <th>col8</th>\n",
       "      <th>col9</th>\n",
       "      <th>col10</th>\n",
       "      <th>col11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1.52101</td>\n",
       "      <td>13.64</td>\n",
       "      <td>4.49</td>\n",
       "      <td>1.10</td>\n",
       "      <td>71.78</td>\n",
       "      <td>0.06</td>\n",
       "      <td>8.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1.52101</td>\n",
       "      <td>13.64</td>\n",
       "      <td>4.49</td>\n",
       "      <td>1.10</td>\n",
       "      <td>71.78</td>\n",
       "      <td>0.06</td>\n",
       "      <td>8.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1.51761</td>\n",
       "      <td>13.89</td>\n",
       "      <td>3.60</td>\n",
       "      <td>1.36</td>\n",
       "      <td>72.73</td>\n",
       "      <td>0.48</td>\n",
       "      <td>7.83</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1.51618</td>\n",
       "      <td>13.53</td>\n",
       "      <td>3.55</td>\n",
       "      <td>1.54</td>\n",
       "      <td>72.99</td>\n",
       "      <td>0.39</td>\n",
       "      <td>7.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1.51766</td>\n",
       "      <td>13.21</td>\n",
       "      <td>3.69</td>\n",
       "      <td>1.29</td>\n",
       "      <td>72.61</td>\n",
       "      <td>0.57</td>\n",
       "      <td>8.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>210</td>\n",
       "      <td>1.51623</td>\n",
       "      <td>14.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.88</td>\n",
       "      <td>72.61</td>\n",
       "      <td>0.08</td>\n",
       "      <td>9.18</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>211</td>\n",
       "      <td>1.51685</td>\n",
       "      <td>14.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.99</td>\n",
       "      <td>73.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.40</td>\n",
       "      <td>1.59</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>212</td>\n",
       "      <td>1.52065</td>\n",
       "      <td>14.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.02</td>\n",
       "      <td>73.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.44</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>213</td>\n",
       "      <td>1.51651</td>\n",
       "      <td>14.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.94</td>\n",
       "      <td>73.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.48</td>\n",
       "      <td>1.57</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>214</td>\n",
       "      <td>1.51711</td>\n",
       "      <td>14.23</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.08</td>\n",
       "      <td>73.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.62</td>\n",
       "      <td>1.67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>215 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     col1     col2   col3  col4  col5   col6  clo7  col8  col9  col10  col11\n",
       "0       1  1.52101  13.64  4.49  1.10  71.78  0.06  8.75  0.00    0.0      1\n",
       "1       1  1.52101  13.64  4.49  1.10  71.78  0.06  8.75  0.00    0.0      1\n",
       "2       2  1.51761  13.89  3.60  1.36  72.73  0.48  7.83  0.00    0.0      1\n",
       "3       3  1.51618  13.53  3.55  1.54  72.99  0.39  7.78  0.00    0.0      1\n",
       "4       4  1.51766  13.21  3.69  1.29  72.61  0.57  8.22  0.00    0.0      1\n",
       "..    ...      ...    ...   ...   ...    ...   ...   ...   ...    ...    ...\n",
       "210   210  1.51623  14.14  0.00  2.88  72.61  0.08  9.18  1.06    0.0      7\n",
       "211   211  1.51685  14.92  0.00  1.99  73.06  0.00  8.40  1.59    0.0      7\n",
       "212   212  1.52065  14.36  0.00  2.02  73.42  0.00  8.44  1.64    0.0      7\n",
       "213   213  1.51651  14.38  0.00  1.94  73.61  0.00  8.48  1.57    0.0      7\n",
       "214   214  1.51711  14.23  0.00  2.08  73.36  0.00  8.62  1.67    0.0      7\n",
       "\n",
       "[215 rows x 11 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql(\"select * from testineuron.glassdata\" , mydb)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\nayak\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Database</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>information_schema</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>mysql</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>performance_schema</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>sakila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>sys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>testineuron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>world</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Database\n",
       "0  information_schema\n",
       "1               mysql\n",
       "2  performance_schema\n",
       "3              sakila\n",
       "4                 sys\n",
       "5         testineuron\n",
       "6               world"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql(\"show databases\" , mydb)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "fd354288a369f680a7322ddff2a06d3b3ac546c5fe22b956c0c96b589b2c4d3d"
  },
  "kernelspec": {
   "display_name": "Python 3.10.4 64-bit",
   "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.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}