Topic: insert value in all the records of the table

I have add a new column (Boolean type to my project) and I like to set to all the records the Value True
I use the script
sqlexecute('INSERT INTO  WORK (KRYFO) VALUES (0)')
but it insert only in the last record the value

2 (edited by brian.zaballa 2022-05-01 18:09:07)

Re: insert value in all the records of the table

use update query if you want to update existing records and set the field to 1 for TRUE.

SQLExecute('UPDATE `work` SET kryfo=1 WHERE 1');
brian

Re: insert value in all the records of the table

Thank you