this post was submitted on 12 Dec 2024
306 points (99.4% liked)
Memes
45895 readers
1012 users here now
Rules:
- Be civil and nice.
- 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.