%defaultDatasource jdbc:h2:mem:db1
%datasources chemistry=jdbc:h2:mem:chemistry
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%';
%%python
from beakerx import *
pp = Plot(title="Title", xLabel="Horizontal", yLabel="Vertical")
pp.add(Line(displayName="Line", x=[1, 4, 6, 8, 10],y=[3, 6, 4, 5, 9]))
press 'Shift' + 'Tab' for doc