tb0Cyjv8

1# Create Database if not exists
2class connectiondb():
3    mdb = mysql.connector.connect(
4        host="localhost",
5        user="root",
6        passwd=""
7    )
8    requete1 = "CREATE DATABASE project_db"
9    requete2 = "CREATE TABLE IF NOT EXISTS employe (ID int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,nom varchar(20) NOT NULL,prenom varchar(20) NOT NULL,date_naissance date,lieu_naissance varchar(20),adresse varchar(50),email varchar(20),telephone varchar(15))"
10    mycursor = mdb.cursor()
11    mycursor.execute(requete1, requete2)
12    mdb.commit()