MySQL SELECT Query in Python with WHERE to get matching records by user input & parameterized quer

All Video tutorials on MySQL Python in Anaconda Environment First we will connect to MySQL database by using SQLAlchemy connection engine. With this connection we will collect data from MySQL database. Here is a sample query to collect all records where class is Four SELECT * FROM student WHERE class=’Four’ from sqlalchemy.exc import SQLAlchemyError q="SELECT * FROM student WHERE class='Four'" try: my_cursor=my_conn.execute(q) my_data=my_cursor.fetchall() for row in my_data: print(row) except SQLAlchemyError as e: error=str(e.__dict__['orig']) print(error) except Exception as e: print(e) else: print("Total Number of rows : ",my_cursor.rowcount) We used fetchall() to get all matching records from the table Getting single record from MySQL database, Query is here SELECT * FROM student WHERE id=4 This will return us single record from our sample student table. We can ask user to input the id of the student and we can display all details of the matching record. Let us try the query to get the record but we will use parameterized query to pass input value ( id here ) to mysql database to get matching record.