Question

write a python program that sends a SQL query to display update data where name starting with a in a given table and count number of rows.​

Answer 1

Answer:

1. Connect to the database by creating a new MySQLConnection object.

2. Create a new MySQLCursor object from the MySQLConnection object and call the execute() method of the MySQLCursor object....

3. Close the cursor and database connection.

Answer 2

See pic to get your answer.