AWS | Project | Create, connect and interact with Amazon RDS using SQL Workbench & Python | Part-4
https://github.com/cloudtechmasters/p...
Establish MySQL database Connection from Python.
Define the SELECT statement query. Here you need to know the table, and it’s column details.
Execute the SELECT query using the cursor.execute() method.
Get resultSet from the cursor object using a cursor.fetchall().
Iterate over the ResultSet and get each row and its column value.
Close the Python database connection.
Catch any SQL exceptions that may come up during the process.
On this page of the site you can watch the video online AWS | Project | Create, connect and interact with Amazon RDS using SQL Workbench & Python | Part-4 with a duration of hours minute second in good quality, which was uploaded by the user Cloud Tech Masters 20 September 2020, share the link with friends and acquaintances, this video has already been watched 5,026 times on youtube and it was liked by 39 viewers. Enjoy your viewing!
