Database Name: Must have at least 6 columns in your table: Column Name (Sqlite Data Types are: text, integer, or real) T
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Database Name: Must have at least 6 columns in your table: Column Name (Sqlite Data Types are: text, integer, or real) T
Statement to drop table: DDL SQL Statement to create table: DML SQL Statement to insert a new row: DML - SQL Statement to retrieve all columns from all rows: DML - SQL Statement to retrieve all columns from one row based on the primary key: DML - SQL Statement to update two fields of one row based on the primary key: DML - SQL Statement to delete one row based on the primary key:
Database Name: Must have at least 6 columns in your table: Column Name (Sqlite Data Types are: text, integer, or real) Table Name: Which column is your primary key? Choose two fields (columns) that you will allow the user to update: Write the SQL statements that you plan to use in the code: DDL - SQL