Meteotemplate Forum

Posted: **Tue Oct 04, 2022 6:18 am**

Hello
please, how is the script to delete the data of the SM1 field from the extraData table, starting from the beginning to 30 sept 2022?
tnx in advance

Posted: **Mon Oct 10, 2022 4:07 pm**

If you mean the sql query to execute in phpmyadmin, you can use something like this:

Code: Select all

UPDATE alldataExtra SET SM1=NULL WHERE DateTime < '2022-09-30 00:00:00'

P.S.
A backup of the database is always a good idea, as these operations could be 'quite destructive'

Meteotemplate Forum

help mysql: how to delete data of a column from date to date

help mysql: how to delete data of a column from date to date

Re: help mysql: how to delete data of a column from date to date