The best way to Create a Main Key for a MySQL Database in Python

You may create a Main Key on your MySQL database in Python as follows.

First, you might want to know if the Main Key already exists.

Possibility 1 – The Main Key doesn’t Exist

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()

mycursor.execute("CREATE TABLE prospects (id INT AUTO_INCREMENT PRIMARY KEY, identify VARCHAR(255), deal with VARCHAR(255))")

Possibility 2 – The Main Key already Exists

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()

mycursor.execute("ALTER TABLE prospects ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY")