How to set default column value in mysql view?

@herminia_bruen 

Unfortunately, you cannot set a default column value for a column in a MySQL view.

A view is a virtual table that is generated based on the result of a query. It is not a physical table and does not store any data itself. Therefore, you cannot set a default value for a column in a view like you would for a regular table.

If you need to have default values for a column, you would need to create a regular table and set the default values on that table. Then you can create a view based on that table if necessary.