FilesExpand file tree

 master

/

MySQL_Databses.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (14 loc) · 353 Bytes

 master

/

MySQL_Databses.py

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (14 loc) · 353 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

import mysql.connector

# MySQl databses details

mydb = mysql.connector.connect(

host="localhost",

user="root",

passwd="",

database="db_name"

)

mycursor = mydb.cursor()

# Execute SQL Query =>>>> mycursor.execute("SQL Query")

mycursor.execute("SELECT column FROM table")

myresult = mycursor.fetchall()

for x in myresult:

print(x)