I want to create a view from a table student and want to add an extra column. does this view take space at disk/file on adding extra column? here is my code:
CREATE OR REPLACE VIEW DETAILS
AS SELECT Name, Serial_number,NULL AS 'additional_field1' from student;
MySQL views never take any space, except for the metadata, that is the definition of the view itself.
They don't store any data, they are more like a macro. When you query the view, it actually runs the query in the view definition.