Page 25 - Phyton_GUIprogrammingwithTkinter

P a ge | 16

e) When executing a SQL select command, the execute () function return a cursor
which can be iterated over with a for loop to access the records returned.

3.2.6 SQLite Commands
The standard SQLite commands are similar to SQL when to interact with relational
databases. The SQLite commands are based on the Table 3.2 below.

Table 3.2: SQLite Commands
No. Commands & Description
1 CREATE
Creates a new table, a view of a table, or other object in database.
2 ALTER
Modifies an existing database object, such as a table.
3 DROP
Deletes an entire table, a view of a table or other object in the database.
4 INSERT
Create a new record and insert into table.
5 UPDATE
Update record if there is any modification on the record.
6 DELETE
Delete record in the table.
7 SELECT
Retrieves certain records from one or more tables.