DROP TABLE IF EXISTS t1; CREATE TABLE t1 (x1 int, fl int); delete from t1; UPDATE t1 SET fl=1; SELECT fl FROM t1 where x1=0;