Views
CREATE VIEW, EK, VIRTUAL, table, banaता hai, JO, EK, STORED, query, PAR, BASED, hai — VIEW, ko, QUERY, karna, MATLAB, HAI, underlying, query, ko, RUN, karna. COMPLEX, JOINS, ko, SIMPLIFY, karta hai reusability, ke, liye.
Views, se, SENSITIVE, COLUMNS, ko, HIDE, kiya, ja, sakta hai (jaise, users, table, ka, EK, view, JISME, password, column, na, ho) — SECURITY, layer, ke, liye, USEFUL, hai.
CREATE VIEW active_customer_orders AS
SELECT users.name, orders.id, orders.amount
FROM users
JOIN orders ON users.id = orders.user_id
WHERE users.status = 'active';
-- Ab, ek, regular, table, ki, tarah, query, karo:
SELECT * FROM active_customer_orders WHERE amount > 500;- View = virtual table, jo, ek, stored, query, PAR, based, hai
- Complex, joins, ko, simplify, karta, hai — reusability, ke, liye
- Sensitive, columns, HIDE, karne, ke, liye, useful — security, layer
Kuch, VIEWS, "updatable" HOTE, HAIN — INKE, through, DIRECTLY, INSERT/UPDATE/DELETE, kiya, ja, sakta hai, JO, underlying, table(s), ko, AFFECT, karta hai. Complex, VIEWS, (JOINs, GROUP BY, ke, saath) generally, updatable, NAHI, hote.
CREATE VIEW active_users AS SELECT id, name, email FROM users WHERE status = 'active';
UPDATE active_users SET name = 'New Name' WHERE id = 1; -- underlying, users, table, update, hoti, haiMySQL, NATIVE, materialized, views, support, NAHI, karta, (unlike, PostgreSQL) — INKE, EQUIVALENT, ke, liye, EK, ACTUAL, TABLE, banake, PERIODICALLY, EK, SCHEDULED, JOB, se, POPULATE, karna, PADТA, hai.