Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Xml Excercise 3

Language: Layout:
View schema
Execution time: 0.05 sec, rows selected: 16, rows affected: 0, absolute service time: 0.17 sec 
edit mode |  history  | discussion
   custid companyname
1 1 NULL
2 2 NULL
   custid companyname
1 NULL Customer NRZBB
2 NULL Customer MLTDN
   custid companyname employeename
1 1 Customer NRZBB Anand Somaiya
2 2 Customer MLTDN NULL
   (No column name)
1 <CustomersOrders><Customer custid="1"><companyname>Customer NRZBB</companyname><employeename>Anand Somaiya</employeename><Order orderid="10692"><orderdate>2007-10-03T00:00:00</orderdate></Order><Order orderid="10702"><orderdate>2007-10-13T00:00:00</orderdate></Order><Order orderid="10952"><orderdate>2008-03-16T00:00:00</orderdate></Order></Customer><Customer custid="2"><companyname>Customer MLTDN</companyname><Order orderid="10308"><orderdate>2006-09-18T00:00:00</orderdate></Order><Order orderid="10926"><orderdate>2008-03-04T00:00:00</orderdate></Order></Customer></CustomersOrders>
   (No column name)
1 Customer NRZBBAnand Somaiya2007-10-03T00:00:002007-10-13T00:00:002008-03-16T00:00:00Customer MLTDN2006-09-18T00:00:002008-03-04T00:00:00
   (No column name)
1 Customer NRZBB Customer MLTDN
   FirstOrLastName
1 <FirstName>fname</FirstName><FirstName>fname3</FirstName>
   (No column name)
1 <Order orderid="10692"><orderdate>2007-10-03T00:00:00</orderdate></Order><Order orderid="10702"><orderdate>2007-10-13T00:00:00</orderdate></Order><Order orderid="10952"><orderdate>2008-03-16T00:00:00</orderdate></Order><Order orderid="10308"><orderdate>2006-09-18T00:00:00</orderdate></Order><Order orderid="10926"><orderdate>2008-03-04T00:00:00</orderdate></Order>
   First Customer New Name
1 New Company Name