<\/p>\n\n\n\n
$python3 dt.py\n$cat dt.py \n# importing required library\nimport mysql.connector\n\n# connecting to the database\ndataBase = mysql.connector.connect(\n\t\t\t\t\thost = \"localhost\",\n\t\t\t\t\tuser = \"jeff\",\n\t\t\t\t\tpasswd = \"sixer\",\n\t\t\t\t\tdatabase = \"learning\" )\n\n# preparing a cursor object\ncursorObject = dataBase.cursor()\n\n# creating table\nstudentRecord = \"\"\"CREATE TABLE STUDENT (\n\t\t\t\tNAME VARCHAR(20) NOT NULL,\n\t\t\t\tBRANCH VARCHAR(50),\n\t\t\t\tROLL INT NOT NULL,\n\t\t\t\tSECTION VARCHAR(5),\n\t\t\t\tAGE INT\n\t\t\t\t)\"\"\"\n\n# table created\ncursorObject.execute(studentRecord)\n\n# disconnecting from server\ndataBase.close()\n$mysql --user=jeff -psixer\nmysql: [Warning] Using a password on the command line interface can be insecure.\nWelcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 9\nServer version: 8.0.30-1 (Debian)\n\nCopyright (c) 2000, 2022, Oracle and\/or its affiliates.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql> use learning;\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\n\nDatabase changed\nmysql> show tables;\n+--------------------+\n| Tables_in_learning |\n+--------------------+\n| STUDENT |\n+--------------------+\n1 row in set (0.00 sec)\n\nmysql> desc STUDENT;\n+---------+-------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+---------+-------------+------+-----+---------+-------+\n| NAME | varchar(20) | NO | | NULL | |\n| BRANCH | varchar(50) | YES | | NULL | |\n| ROLL | int | NO | | NULL | |\n| SECTION | varchar(5) | YES | | NULL | |\n| AGE | int | YES | | NULL | |\n+---------+-------------+------+-----+---------+-------+\n5 rows in set (0.20 sec)\n\nmysql><\/pre>\n","protected":false},"excerpt":{"rendered":"$python3 dt.py $cat dt.py # importing required library import mysql.connector # connecting to the database dataBase = mysql.connector.connect( host = “localhost”, user = “jeff”, passwd = “sixer”, database = “learning” ) # preparing a cursor object cursorObject = dataBase.cursor() # creating table studentRecord = “””CREATE TABLE STUDENT ( NAME VARCHAR(20) NOT NULL, BRANCH VARCHAR(50), ROLL … <\/p>\n