C. B . PATEL COMPUTER COLLEGE AND J. N. M.
P SIENCE COLLEGE
SYBCA SEM 3
PYTHON INTERACTION WITH SQLITE
PRACTICAL ASSIGNMENT-1
1. Write a Python program to create SQLite database connection to a database
that resides in the memory.
2. Write a Python program to connect a database and create a SQLite table within
the database.
3. Write a Python program to list the tables of given SQLite database file.
4. Write a Python program to create a table and insert some records in that table.
Finally selects all rows from the table and display the records.
5. Write a Python program to insert values to a table from user input.
6. Write a Python program to count the number of rows of a given SQLite table.
7. Write a Python program to update a specific column value of a given table and
select all rows before and after updating the said table.
8. Write a Python program to update all the values of a specific column of a given
SQLite table.
9. Write a Python program to delete a specific row from a given SQLite table.
10. Write a Python program to alter a given SQLite table.
NOTE:- YOU CAN USE/CREATE TABLES OF YOUR CHOICE FOR ABOVE
PROGRAMS.
TIP:- USE SEPARATE TABLES FOR EACH PROGRAM WHEREVER
REQUIRED
