$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 INT NOT NULL, SECTION VARCHAR(5), AGE INT )""" # table created cursorObject.execute(studentRecord) # disconnecting from server dataBase.close() $mysql --user=jeff -psixer mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.30-1 (Debian) Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use learning; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +--------------------+ | Tables_in_learning | +--------------------+ | STUDENT | +--------------------+ 1 row in set (0.00 sec) mysql> desc STUDENT; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | NAME | varchar(20) | NO | | NULL | | | BRANCH | varchar(50) | YES | | NULL | | | ROLL | int | NO | | NULL | | | SECTION | varchar(5) | YES | | NULL | | | AGE | int | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 5 rows in set (0.20 sec) mysql>