add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (a int primary key not null);
insert into t (a) values (123), (456);
2 rows affected
alter table t add is_new int default 1;
update t set is_new = 0;
2 rows affected
create view v as select a from t;
select * from v;
a
123
456
insert into v (a) values (789), (444);
2 rows affected
select * from t where is_new = 1;
a is_new
444 1
789 1