ag-informatics / ag-informatics-course

Intro to Ag Informatics course, Ankita Raturi, ASM 532 Purdue University, Current Offering: Fall 2024
http://aginformaticslab.org/
Other
8 stars 26 forks source link

Add quotes to example SQL insert #47

Closed jdavidpeery closed 1 month ago

jdavidpeery commented 1 month ago

In Lab 3, the first SQL insert statement is the following -

insert into crops (crop_name, maturity_date) values (carrot, 70);

which I believe? should be changed to -

insert into crops (crop_name, maturity_date) values ('carrot', 70);

, adding single quotes around carrot, otherwise it didn't work on my MacOS SQLite3

jdavidpeery commented 1 month ago

@tame0001

tame0001 commented 1 month ago

It should have quote. My mistake. Fixed.