1
cb219
2d

Thought I would be clever to batch insert a bunch of data into the db with sql, with the catch that the data of a specific column should have a zero-padded number as prefix, counting up from 0. Ask AI for suggestion. Generates some SQL beyond my basic understanding. No way I'm gonna run that! Can't be bothered for an explanation, don't have the time. I realize my assumption to SQL my way through failed right from the start. Instead I let AI generate a python script to create a CSV with the desired data. A few iterations of testing, I take the result file and import it into the db. Done.

Comments
  • 2
    So, zero padding was the problem and AI was the solution you came up with?

    Our species is lost, isn't it?
  • 0
    BEGIN TRANSACTION
    ROLLBACK
  • 0
    @TrayKnots maybe it's lost?
    Padding was part of the problem, and my SQL skills. Thought I could save time with the help of AI. Doing it "quick and easy" using the db itself. "How hard can this be?" Was one way to achieve it. Bad assumption when SQL is not the tool you use regularly.
Add Comment