mysql_python/mysql_exemple1.py at main · ikeecode/mysql_python · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
import mysql.connector as mc
from me import me


mydb = mc.connect(
    host = 'localhost'
    ,user = 'kaba'
    ,password = me.me
    # ,database = 'Eleves'
)

if mydb:
    mycursor = mydb.cursor()

mycursor.execute("SHOW DATABASES")
# affiche les differentes bases de donnees
for x in mycursor:
    print(x)

choice = input("Enter database name: ")
command = "USE "+ choice
mycursor.execute(command)

mycursor.execute("SHOW TABLES")
# affiches les differentes tables
for x in mycursor:
    print(x)

choice = input("enter table name: ")
mycursor.execute("SELECT * FROM " + choice)
# if mydb:
#     print('ok')
# mycursor = mydb.cursor()
# mycursor.execute("USE Eleves")
# mycursor.execute("SELECT * FROM Eleves")
myresult = mycursor.fetchall()

if myresult:
    for x in myresult:
        print(x)