Html

Keyword HTML

AlaSQL can read data from a HTML table and store data into a HTML table. This only works in the browser.

Syntax:

    SELECT column INTO HTML(cssSelector,options) FROM tableid;
    SELECT column FROM HTML(cssSelector,options) ;

Data from HTML table

    alasql('SELECT * FROM HTML("#MyTable", {headers:true})');

Data into HTML table

    alasql('SELECT * INTO HTML("#MyTable", {headers:true}) FROM ?',[data]);

See also: CSV, TAB, TSV, XLSX, JSON