How to create a table Using Python with MySQL

import mysql.connector
con=mysql.connector.connect(host='localhost',user='root',password='silan', database='silandb')
obj=con.cursor()

#obj.execute("create table employee (ename varchar(200),esal int(20) )")

obj.execute("show tables")
for k in obj:
    print(k)




Output:


About the Author



Silan Software is one of the India's leading provider of offline & online training for Java, Python, AI (Machine Learning, Deep Learning), Data Science, Software Development & many more emerging Technologies.

We provide Academic Training || Industrial Training || Corporate Training || Internship || Java || Python || AI using Python || Data Science etc





 PreviousNext