How to fetch data from SQL query in Python

Question

Good Afternoon, I wrote a query in MySQL, and I want to execute the same query in Python. The Code I wrote as Follows. 1.

import mysql.connector
from mysql.connector import Error


try:
connection = mysql.connector.connect(host='localhost',
                                      database='AdventureWorks2012',
                                      user='root',
                                      password='r@#*****')

sql_select_Query = "select * from Person.person"
    cursor = connection.cursor()
    cursor.execute(sql_select_Query)
    records = cursor.fetchall()

However, I'm getting following error message while running part two- ''File "", line 5 password='r@#*****') ^ SyntaxError: unexpected EOF while parsing''

Any suggestion please how to overcome this problem?

Does this answer your question? How to fix unexpected EOF while parsing in python 3.6? — 001
– 001, Commented Nov 26, 2020 at 13:00

creed · Accepted Answer · 2020-11-26 13:14:44Z

1

You are missing the except clause:

try:
    connection = mysql.connector.connect(host='localhost',
                                      database='AdventureWorks2012',
                                      user='root',
                                      password='r@#*****')
except Exception as e:
    print(e)

You should check the documentation for more information.

edited Nov 26, 2020 at 13:14

answered Nov 26, 2020 at 13:02

creed

1,4271 gold badge11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fetch data from SQL query in Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related