SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table services (id int, name varchar); insert into services values (1, 'service1'), (2, 'service2'); create table settings (id int, name varchar, default_value varchar); insert into settings values (1, 'setting1', '10'), (2, 'setting2', 'false'); create table services_settings (id int, service_id int, setting_id int, value varchar); insert into services_settings values (1, 1, 1, '50'), (2, 2, 2, true); select services.id, coalesce(services_settings.value, settings.default_value) from services left join services_settings on services_settings.service_id = services.id cross join settings where settings.name = 'setting1'
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear