I'm new to AlaSQL, everything works fine but when I try to delete rows I run into an error message, I try this:
alasql.options.autocommit = true;
alasql("CREATE localStorage DATABASE IF NOT EXISTS lsdb");
alasql("ATTACH localStorage DATABASE lsdb AS db");
alasql("CREATE TABLE IF NOT EXISTS db.people (Id INT,FirstName STRING,LastName STRING);");
alasql("INSERT INTO db.people VALUES (1,'Peter','Peterson'), (2,'Eric','Ericson'), (3,'John','Johnson');");
alasql("DELETE FROM db.people");
alasql("SELECT * INTO HTML('#res',{headers:true}) FROM db.people;");
I get this error:
What am I missing?
Made some changes to the code and this works: