![]() To insert data in a table, we use the INSERT INTO statement. Open your mydatabase.db file with the program, and you should see your table: To check if our table is created, you can use the DB browser for SQLite to view your table. The commit() method saves all the changes we make. In the above code, we have defined two methods, the first one establishes a connection and the second method creates a cursor object to execute the create table statement. The code will be like this: import sqlite3ĬursorObj.execute("CREATE TABLE employees(id integer PRIMARY KEY, name text, salary real, department text, position text, hireDate text)") Let’s create employees with the following attributes: employees (id, name, salary, department, position, hireDate)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |