Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 37 of 47

Interface Python with SQL — Question 15

Back to all questions
15
Question

Question 15

Create a table EMPLOYEE with Fields FIRST_NAME, LAST_NAME, AGE, GENDER and INCOME.

Answer 
import mysql.connector
mydb = mysql.connector.connect(host = 'localhost', 
                               user = 'root', 
                               passwd = 'tiger', 
                               database = "kboat_cbse_12")
mycursor = mydb.cursor()
mycursor.execute("CREATE table EMPLOYEE (FIRST_NAME VARCHAR(45), 
                LAST_NAME VARCHAR(45), 
                AGE INTEGER, 
                GENDER VARCHAR(10), 
                INCOME FLOAT)")
mydb.commit()
mycursor.close()
mydb.close()