SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl (column_1 int, column_2 varchar(64)); SELECT SUM(column_1) FROM tbl WHERE column_2 = 'Test'; SELECT IFNULL(SUM(column_1), 0) FROM tbl WHERE column_2 = 'Test'; SELECT COALESCE(SUM(column_1), 0) FROM tbl WHERE column_2 = 'Test';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear