SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tableA ( id int auto_increment primary key, signatured int, signatured_by varchar(32) null ); insert into tableA (signatured) values (0), (0), (1), (1), (0), (1), (1), (0), (1), (1), (0), (1), (1); select * from tableA; create table tableB (tableA_id int, approved int); insert into tableB (tableA_id, approved) values (1, 0), (2, 1), (3, 1), (4, 0), (5, 1), (6, 1), (7, 0), (8, 1), (9, 1), (10, 0); select * from tableB; update tableA set signatured_by = 'digital' where signatured = 1; select * from tableA; update tableA set signatured_by = 'manual' where signatured = 0 && ( select approved = 1 from tableB where tableA_id = tableA.id ); select * from tableA;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear