SQLize | PHPize | SQLtest

CREATE TABLE table1 ( box_id character varying(50), name character varying(50), another_name character varying(50), product character varying(60), incoming character varying(15), output character varying(15) ); INSERT INTO table1 (box_id, name, another_name, product, incoming, output) VALUES (1, 'box1', null, 'PRODUCT1', '5', null), (2, 'box2', null, 'PRODUCT2', '6', null), (1, null, 'another_box1', 'PRODUCT1', null, '5'); select * from table1; CREATE TABLE result1 ( box_id character varying(50), name character varying(50), another_name character varying(50), product character varying(60), incoming character varying(15), output character varying(15), balance character varying(15) ); INSERT INTO result1 (box_id, name, another_name, product, incoming, output, balance) VALUES (1, 'box1', 'another_box1', 'PRODUCT1', '5', '5', '0'), (2, 'box2', null, 'PRODUCT2', '6', null, '6'); select * from result1