w3resource

Python SQLite Database - Exercises, Practice, Solution

Python SQLite Database [ 13 exercises with solution ]

[An editor is available at the bottom of the page to write and execute the scripts.  Go to the editor]

1. Write a Python program to create a SQLite database and connect with the database and print the version of the SQLite database.
Click me to see the sample solution

2. Write a Python program to create a SQLite database connection to a database that resides in the memory.
Click me to see the sample solution

3. Write a Python program to connect a database and create a SQLite table within the database.
Click me to see the sample solution

4. Write a Python program to list the tables of given SQLite database file.
Click me to see the sample solution

5. 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.
Click me to see the sample solution

6. Write a Python program to insert a list of records into a given SQLite table.
Click me to see the sample solution

7. Write a Python program to insert values to a table from user input.
Click me to see the sample solution

8. Write a Python program to count the number of rows of a given SQLite table.
Click me to see the sample solution

9. 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.
Click me to see the sample solution

10. Write a Python program to update all the values of a specific column of a given SQLite table.
Click me to see the sample solution

11. Write a Python program to delete a specific row from a given SQLite table.
Click me to see the sample solution

12. Write a Python program to alter a given SQLite table.
Click me to see the sample solution

13. Write a Python program to create a backup of a SQLite database.
Click me to see the sample solution

Python Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz



Follow us on Facebook and Twitter for latest update.

Python: Tips of the Day

Returns the symmetric difference between two lists, after applying the provided function to each list element of both:

Example:

def tips_symmetric_difference_by(p, q, fn):
  _p, _q = set(map(fn, p)), set(map(fn, q))
  return [item for item in p if fn(item) not in _q] + [item for item in q if fn(item) not in _p]
from math import floor
print(tips_symmetric_difference_by([4.2, 2.4], [4.6, 6.8],floor))

Output:

[2.4, 6.8]

 

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook