-- Entrance example.  See http://dbentrance.com/Developers.html
--
-- (I used Tools | Generate a reference table...
-- to make a table named "reference1", then
-- "SQL to create table and load data..."
-- to help)


/* drop table if exists reference1; */

CREATE TABLE `reference1` (
  `item` int(11) DEFAULT NULL
);

insert into `reference1` values('1');
insert into `reference1` values('2');
insert into `reference1` values('3');
insert into `reference1` values('4');
insert into `reference1` values('5');
insert into `reference1` values('6');
insert into `reference1` values('7');
insert into `reference1` values('8');
insert into `reference1` values('9');
insert into `reference1` values('10');

/* drop table if exists foo; */

create table foo (
  x double,
  y double,
  highlight varchar(255)
);

insert into foo
select
  t1.item, t2.item, ''
  from reference1 as t1, reference1 as t2;

UPDATE foo 
    SET highlight = "RED"
    WHERE x = y + 3;
      
UPDATE foo 
    SET highlight = "ORANGE"
    WHERE x = y;

PLOT XY
    X, FILLED VERY LIGHT BLUE TRIANGLE, COLOR OVERRIDE
  SELECT x, y, highlight from foo;