Question: A query of the table information for table Journal returns the following information: cid name type notnull dflt_value pk 0 0 JournalID INTEGER 0 None
A query of the table information for table Journal returns the following information:
| cid | name | type | notnull | dflt_value | pk | |
|---|---|---|---|---|---|---|
| 0 | 0 | JournalID | INTEGER | 0 | None | 1 |
| 1 | 1 | Name | TEXT | 1 | None | 0 |
NOTE: JournalID is an AUTOINCREMENT number.
Write only the SQL statement needed to insert a new journal with the name "Computers and Education" into the database.
For example:
| Test | Result |
|---|---|
SELECT * FROM Journal; | JournalID Name ---------- ----------------------- 1 Computers and Education |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
