Updatable Views in MySQL

Can a View Be Updated?

Example

CREATE VIEW active_students AS
SELECT roll_no, name, status FROM students WHERE status = 'active';

UPDATE active_students SET name = 'Aman K' WHERE roll_no = 1;
-- this updates the real students table

When a View is NOT Updatable

• Uses aggregate functions (SUM, COUNT...).
• Has GROUP BY or DISTINCT.
• Joins multiple tables in a complex way.

Summary

• Simple single-table views can be updated, changing the base table.
• Views with aggregates, GROUP BY or DISTINCT are read-only.

क्या View Update हो सकती है?

Example

CREATE VIEW active_students AS
SELECT roll_no, name, status FROM students WHERE status = 'active';

UPDATE active_students SET name = 'Aman K' WHERE roll_no = 1;
-- यह असली students table update करता है

View कब Updatable नहीं

• Aggregate functions (SUM, COUNT...) use करती हो।
• GROUP BY या DISTINCT हो।
• कई tables जटिल तरीके से join करती हो।

सारांश

• Simple single-table views update हो सकती हैं, base table बदलते हुए।
• Aggregates, GROUP BY या DISTINCT वाली views read-only होती हैं।