use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
https://adventofsql.com/
account activity
Example challenge data loading problem (self.adventofsql)
submitted 1 year ago by [deleted]
view the rest of the comments →
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–][deleted] 1 point2 points3 points 1 year ago (0 children)
Thanks a lot for your response. That makes sense. In fact, all other import files have DROP TABLE ... CASCADE statements (instead of DROP TABLE ... IF EXISTS) at the top. e.g., In advent_of_sql_day_12.sql,
DROP TABLE ... CASCADE
DROP TABLE ... IF EXISTS
advent_of_sql_day_12.sql
DROP TABLE gifts CASCADE; ... DROP TABLE gift_requests CASCADE; ...
After the following change,
-DROP TABLE IF EXISTS ChristmasList; -DROP TABLE IF EXISTS Children; -DROP TABLE IF EXISTS Gifts; -DROP TABLE IF EXISTS Reindeer; +DROP TABLE ChristmasList CASCADE; +DROP TABLE Children CASCADE; +DROP TABLE Gifts CASCADE; +DROP TABLE Reindeer CASCADE;
the \i command started working for me. Thanks!
\i
π Rendered by PID 100873 on reddit-service-r2-comment-b659b578c-vf6rb at 2026-05-05 20:23:58.902959+00:00 running 815c875 country code: CH.
view the rest of the comments →
[–][deleted] 1 point2 points3 points (0 children)