SQL · Theory

time()

← All stacks

Theory

251/439

time()

Meera only reaches for time() when time on Meera's board has to stay correct in a viva board.

Keep time() small. Meera should finish time on Meera's board in a few lines, not a 40-line dump.

Skip time() and only reciting the name of time shows up in a viva board.

Use time() when time on Meera's board must stay clear. If a simpler SQL step works, use that instead.

If time on Meera's board breaks under time(), check only reciting the name of time first.

Place time() next to nearby SQL work — one time step Meera can write from memory is the link.

Viva for time() — what it is → one time step Meera can write from memory → the mistake (only reciting the name of time).

Exam tip

For time(): definition + a viva board + one failure.

time() — sample query

-- time()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

time(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

Deftime() — Meera uses it for time on Meera's board in a viva board.
Ruletime() → one time step Meera can write from memory.
Remembertime() + InnoDB (a viva board).
Usetime() in a viva board (time on Meera's board).
Traptime() — only reciting the name of time.
Extime() → time on Meera's board.

-- time() CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

time()

time() — sample query

Short notes

Questions

time()

time() — sample query

Short notes

Questions