Pinned Loading

1. update-record.sql update-record.sql

   1

   update worker

   2

   set compensation = 200000,

   3

   worker_code = 'CODE-X'

   4

   where id = 3

2. select-from-where-2.sql select-from-where-2.sql

   1

   select p.project_name, w.worker_name

   2

   3

   from project p, worker w, project_worker_map m

   4

   where m.project_id = p.id

   5

3. create-table.sql create-table.sql

   1

   create table workerX (id integer not null, name varchar(255), compensation double not null, manager_id integer not null)

4. populate.sql populate.sql

   1

   insert into workerX (id, name, compensation, manager_id) values (1, 'One First', 50000, 5)

   2

   insert into workerX (id, name, compensation, manager_id) values (2, 'Two Second', 70000, 5)

   3

   insert into workerX (id, name, compensation, manager_id) values (3, 'Three Third', 90000, 5)

   4

   insert into workerX (id, name, compensation, manager_id) values (4, 'Four Fourth', 180000, 5)

   5

   insert into workerX (id, name, compensation, manager_id) values (5, 'Five Fifth', 160000, 9)

5. utils.js utils.js

   1

   2

   function formatValue(ctx, value, recurseTimes) {

   3

     // Provide a hook for user-specified inspect functions.

   4

     // Check that value is an object with an inspect function on it

   5

     if (ctx.customInspect &&