Tables as storage

Second, tables could be used to store basic functions used for more complex #calculations… Campbell-Kelly 2009,14

→ author: Francis Hunger, published on: 2017-Mar-08

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

VERSION

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

SHOW

FULL

COLUMNS

FROM

DELETE

FROM

WHERE

SELECT

FROM

WHERE

DELETE

FROM

WHERE

INSERT

INTO

VALUES

ON

DUPLICATE

KEY

UPDATE

VALUES

VALUES

VALUES

INSERT

INTO

VALUES

ON

DUPLICATE

KEY

UPDATE

VALUES

VALUES

VALUES

SELECT

FROM

WHERE

LIMIT

SELECT

ID

FROM

WHERE

IN

AND

IN

SELECT

FROM

WHERE

AND

AND

ORDER

BY

DESC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

SELECT

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

ASC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT