SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DROP SCHEMA IF EXISTS project CASCADE; CREATE SCHEMA project; DROP TABLE IF EXISTS project.Patient; CREATE TABLE project.Patient ( ID INTEGER , value VARCHAR(30) ); INSERT INTO project.patient(id, value) VALUES(100, '566'); INSERT INTO project.patient(id, value) VALUES(null, '567'); INSERT INTO project.patient(id, value) VALUES(null, '596'); INSERT INTO project.patient(id, value) VALUES(104, null); select * from project.patient where id in (100, null);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear