Skip to content

Instantly share code, notes, and snippets.

@lmas3009

lmas3009/createtable.py

Created February 17, 2021 13:09
Show Gist options
  • Save lmas3009/ed640a6cfe3f01b534cebf913bbe3d0e to your computer and use it in GitHub Desktop.
Save lmas3009/ed640a6cfe3f01b534cebf913bbe3d0e to your computer and use it in GitHub Desktop.
Download ZIP
Flask CRUD Operations
Raw
createtable.py
import pymysql as Mysql
mydb = Mysql.connect(host="localhost",user="root",password="",database="crudflask")
mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE userinfo(Id INT NOT NULL AUTO_INCREMENT,Name CHAR(20),EmailId Char(30),Gender Char(7),Age CHAR(10), ClgName CHAR(40),PRIMARY KEY (Id))")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment