Page 1 of 1
Database Name: Must have at least 6 columns in your table: Column Name (Sqlite Data Types are: text, integer, or real) T
Posted: Tue Jul 12, 2022 8:15 am
by answerhappygod
- Database Name Must Have At Least 6 Columns In Your Table Column Name Sqlite Data Types Are Text Integer Or Real T 1 (51.79 KiB) Viewed 33 times
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
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: