Aug-18-2022, 09:00 AM
(Aug-18-2022, 08:15 AM)stsxbel Wrote: An entry appears in the table with values, for example prod1=0.0/ prod2=0.0/ prod3=0.0. And there can be a lot of such records in a day. I would like to make a python script that will be run by cron and delete all entries from 0.0. But there is data like: prod1=34.2/ prod2=0.0/ prod3=0.0 this line should be left.
To me, this is a contradiction: delete
prod2=0.0 / prod3=0.0 but prod2=0.0 / prod3=0.0 should be left ??!!I work with a SQL database every day and the best way to keep the data clean, is to not have any garbage written to it. As the saying goes: GIGO
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
