Closed lbpassos closed 2 months ago
Trying to solve the exercise with input data in a .csv file gives an error (only at check50).
.import --csv "secrets.csv" "secrets_import" gives the following error (the error does not exist in my local machine):
.import --csv "secrets.csv" "secrets_import"
check50 error: :( private.sql creates a view named "message" without error Error when executing statement: near ".": syntax error
:( private.sql creates a view named "message" without error Error when executing statement: near ".": syntax error
Format document in VSCode error: Unable to format SQL: Error: Parse error at token: . at line 41 column 1 Unexpected DOT token
Unable to format SQL: Error: Parse error at token: . at line 41 column 1 Unexpected DOT token
I manage to solve the exercise inserting manually the values:
INSERT INTO "secrets_import" ("sentence_pos", "character_pos", "length_from_character") VALUES (14, 98, 4), (114, 3, 5), (618, 72, 9), (630, 7, 3), (932, 12, 5), (2230, 50, 7), (2346, 44, 10), (3041, 14, 5);
For questions on problem sets, best to post in any of CS50's communities, https://cs50.harvard.edu/x/communities/, so that any of us can answer! Or you can ask the duck at https://cs50.ai!
Trying to solve the exercise with input data in a .csv file gives an error (only at check50).
.import --csv "secrets.csv" "secrets_import"
gives the following error (the error does not exist in my local machine):check50 error:
:( private.sql creates a view named "message" without error Error when executing statement: near ".": syntax error
Format document in VSCode error:
Unable to format SQL: Error: Parse error at token: . at line 41 column 1 Unexpected DOT token
I manage to solve the exercise inserting manually the values:
INSERT INTO "secrets_import" ("sentence_pos", "character_pos", "length_from_character") VALUES (14, 98, 4), (114, 3, 5), (618, 72, 9), (630, 7, 3), (932, 12, 5), (2230, 50, 7), (2346, 44, 10), (3041, 14, 5);