SQL · Theory

Load Data Infile

Theory

417/439

Load Data Infile

Load Data Infile is a SQL idea you prove with Load Data Infile on Arun's board, not with a slogan.

Load Data Infile order: meaning → one Load Data Infile step Arun can write from memory → one limit. Dumping ten features helps nobody.

Load Data Infile exists so Arun can keep Load Data Infile on Arun's board correct in a small live site.

Arun ships Load Data Infile in a small live site. That is the use case worth saying.

Don’t do this with Load Data Infile: copy-pasting Load Data Infile without a dry-run. Interviewers spot it in ten seconds.

After Load Data Infile, Arun should still remember copy-pasting Load Data Infile without a dry-run.

Viva for Load Data Infile: what it is → one Load Data Infile step Arun can write from memory → the mistake (copy-pasting Load Data Infile without a dry-run).

Exam tip

Say Load Data Infile in one breath, then one Load Data Infile step Arun can write from memory, then copy-pasting Load Data Infile without a dry-run.

Load Data Infile — sample query

-- Load Data Infile
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;

Load Data Infile: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefLoad Data Infile — Arun uses it for Load Data Infile on Arun's board in a small live site.
RuleLoad Data Infile → one Load Data Infile step Arun can write from memory.
RememberLoad Data Infile + an index (a small live site).
UseLoad Data Infile in a small live site (Load Data Infile on Arun's board).
TrapLoad Data Infile — copy-pasting Load Data Infile without a dry-run.
ExLoad Data Infile → Load Data Infile on Arun's board.

-- Load Data Infile 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;

Load Data Infile

Load Data Infile — sample query

Short notes

Questions

Load Data Infile

Load Data Infile — sample query

Short notes

Questions