this post was submitted on 12 Dec 2024
311 points (99.4% liked)

Memes

45899 readers
2178 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
gary_host_laptop@lemmy.ml
sexy_peach@feddit.de
cyclohexane@lemmy.ml
cypherpunks@lemmy.ml
311
Aced it (sh.itjust.works)
submitted 2 weeks ago by rastro@sh.itjust.works to c/memes@lemmy.ml
6 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] alcoholicorn@lemmy.ml 7 points 2 weeks ago* (last edited 2 weeks ago)

You can also use BULK INSERT for csvs or just INSERT INTO and some text editing depending on the specifics.

This is more for one-off stuff like analyzing some 10,000 row spreadsheet you've been handed that you could probably do with formulas in excel, but it's easier to use sql, but not worth building a proper process for.