Dette gratis onlineverktøyet lar deg konvertere SQL til XML. Du trenger ikke å laste ned eller installere programvare. Klikk for å konvertere filen nå.
Eksempel fra SQL til XML
Inndata
CREATE TABLE peoples(
id INTEGER PRIMARY KEY,
name CHAR(20),
age CHAR(2)
);
INSERT INTO peoples VALUES (1, 'name 1', '22');
INSERT INTO peoples VALUES (2, 'name 2', '33');
INSERT INTO peoples VALUES (3, 'name 3', '44');
INSERT INTO peoples VALUES (4, 'name 4', '55');
SELECT * FROM peoples
Utdata
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<row-0>
<id>1</id>
<name>name 1</name>
<age>22</age>
</row-0>
<row-1>
<id>2</id>
<name>name 2</name>
<age>33</age>
</row-1>
<row-2>
<id>3</id>
<name>name 3</name>
<age>44</age>
</row-2>
<row-3>
<id>4</id>
<name>name 4</name>
<age>55</age>
</row-3>
</root>