(Jun-26-2022, 10:44 PM)Extra Wrote: Is there a way to program this so the values only get inserted when the table is first created (Table does not exist), and if the table does exist, don't insert those values because they're already there.
Have you tried 'SELECT' on said data values, as a test, before running the 'INSERT' statement? The idea being that if 'SELECT' returns 'True', then the data is there and as such you can skip over the 'INSERT'. If it returns 'False' (or possibly, 'Null'), then have the 'INSERT' do its thing.
Sig:
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein