clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2042839 fiddles created (16594 in the last week).

CREATE TABLE customers ( id int NOT NULL, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, city VARCHAR(50) NOT NULL, state VARCHAR(5), PRIMARY KEY (id) ); INSERT INTO customers (id, first_name, last_name, city, state) VALUES (1, 'François', 'Tremblay', 'Montreal', 'QC'), (2, 'Bjørn', 'Hansen', 'Oslo',null), (3, 'Helena', 'Holý', 'Prague', null), (4, 'Fernanda', 'Ramos', 'Brasília', 'DF'); SELECT query_to_xml( 'SELECT t.id "Id" , t.first_name "FirstName" , t.last_name "LastName" , t.city "City" , t.state "State" FROM customers t LIMIT 2', true , false, '')
4 rows affected
query_to_xml
<table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <row> <Id>1</Id> <FirstName>François</FirstName> <LastName>Tremblay</LastName> <City>Montreal</City> <State>QC</State> </row> <row> <Id>2</Id> <FirstName>Bjørn</FirstName> <LastName>Hansen</LastName> <City>Oslo</City> <State xsi:nil="true"/> </row> </table>
 hidden batch(es)