INTERFACE PYTHON WITH SQL DATABASE

[Pages:2]INTERFACE PYTHON WITH SQL DATABASE

ASSIGNMENTS

1. Mention one difference between fetchone() and fetchall() method. 2. Which function is used to check the successful connection 3. What are the multiple ways to retrieve data? 4. Write down the command to install connectivity package? 5. What is result set, explain with example? 6. Use of functions in connectivity - INSERT, UPDATE, DELETE, ROLLBACK 7. Write code for database connectivity? 8. Write python-mysql connectivity to retrieve all the data of table

student. 9. Write a MySQL-Python connectivity to retrieve data from city table for

employees with id ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download