EVOLUTION-MANAGER

Edit File: xml_html.result

SET NAMES utf8; # # Testing HTML like XML file # CREATE TABLE beers ( `Name` CHAR(16) FIELD_FORMAT='brandName', `Origin` CHAR(16) FIELD_FORMAT='origin', `Description` CHAR(32) FIELD_FORMAT='details') ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='beers.xml' TABNAME='table' OPTION_LIST='xmlsup=domdoc,rownode=tr,colnode=td'; SELECT * FROM beers; Name Origin Description Huntsman Bath, UK Wonderful hop, light alcohol Tuborg Danmark In small bottles DROP TABLE beers; # # Testing HTML file # CREATE TABLE coffee ( `Name` CHAR(16), `Cups` INT(8), `Type` CHAR(16), `Sugar` CHAR(4)) ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='coffee.htm' TABNAME='TABLE' HEADER=1 OPTION_LIST='xmlsup=domdoc,Coltype=HTML'; SELECT * FROM coffee; Name Cups Type Sugar T. Sexton 10 Espresso No J. Dinnen 5 Decaf Yes DROP TABLE coffee;