drop table if exists color;
CREATE TABLE color (
  id int(11) NOT NULL,
  name varchar(45) NOT NULL,
  code varchar(10),
  PRIMARY KEY (id)
);

INSERT INTO color (id, name, code) VALUES (1001,'AliceBlue','#F0F8FF');
INSERT INTO color (id, name, code) VALUES (1002,'AntiqueWhite','#FAEBD7');
INSERT INTO color (id, name, code) VALUES (1003,'Aqua','#00FFFF');
INSERT INTO color (id, name, code) VALUES (1004,'Aquamarine','#7FFFD4');
INSERT INTO color (id, name, code) VALUES (1005,'Azure','#F0FFFF');
INSERT INTO color (id, name, code) VALUES (1006,'Beige','#F5F5DC');
INSERT INTO color (id, name, code) VALUES (1007,'Bisque','#FFE4C4');
INSERT INTO color (id, name, code) VALUES (1008,'Black','#000000');

SELECT * FROM color WHERE name LIKE 'A%';

select * into ${colorTable} from color;

%%javascript
beaker.displayHTML(this, beaker.colorTable.values+"")

Autocomplete

s

SELECT * FROM color WHE

INSERT INTO color (id, name, code) VA

%%beakerDB 

%%