SQL · Theory

AND

← All stacks

Theory

46/439

AND

AND is a SQL idea you prove with AND on Riya's board, not with a slogan.

For AND, InnoDB is in play. Don’t blame it until you have traced AND on Riya's board.

Skip AND and only reciting the name of AND shows up in a small live site.

AND shows up in a small live site. Name AND on Riya's board, not “a real-world scenario”.

AND trap — only reciting the name of AND. Riya loses marks for that every viva.

AND is not a lonely heading. Riya ties it to AND on Riya's board.

One breath for AND, then AND on Riya's board, then only reciting the name of AND. Sit down.

Exam tip

Say AND in one breath, then one AND step Riya can write from memory, then only reciting the name of AND.

AND — sample query

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50);
SELECT * FROM products
WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

AND — wHERE combines predicates with AND/OR; LIKE does pattern match.

Short notes

DefAND — Riya uses it for AND on Riya's board in a small live site.
RuleAND → one AND step Riya can write from memory.
RememberAND + InnoDB (a small live site).
UseAND in a small live site (AND on Riya's board).
TrapAND — only reciting the name of AND.
ExAND → AND on Riya's board.

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL); INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50); SELECT * FROM products WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

AND

AND — sample query

Short notes

Questions

AND

AND — sample query

Short notes

Questions