information_schema.columns.is_updatable

Note:

YES if the column is updatable, NO if not (Columns in base tables are always updatable, columns in views not necessarily)

Note:

YES if the column is updatable, NO if not (Columns in base tables are always updatable, columns in views not necessarily)

Note:

Whether or not the column is able to be updated. Possible values: YES or NO.