1/2/2023 0 Comments Python sqlite tutorialThe table sqlite_sequence is there because if you specified the consumer_id field to be auto-incremented, SQLite creates a separate table to maintain the sequences. Once you followed this, click on the OK button and the table consumers should appear under the database that you created sometime back. The DB Browser tool lets you do this very efficiently. You can also see the respective SQL to create the table. If you look closely at the above figure, you will see that it contains the exact details that you wanted to be incorporated in the table consumers. To create a table, click on the Create Table tab and you will be prompted to enter the details of the table that you wish to create. Note: If you are familiar with database schema designing, you might recollect that the field consumer_id is the primary key of the table (that is why it is underlined).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |