print( myconn close(outputfig created new database creating the table we will create the new table employee we have to mention the database name while establishing the connection object we can create the new table by using the create table statement of sql in our database pythondbthe table employee will have the four columnsi nameidsalaryand department_id initially import mysql connector #create the connection object myconn mysql connector connect(host "localhost"user "root", asswd "google",database "pythondb" #creating the cursor object cur myconn cursor( try #creating table with name employee having four columns na meidsalaryand department id dbs cur execute("create table employee(name varchar( not nulli int( not null primary keysalary float not nulldept_id int not nul )"