I have created a new view in my MariaDB database using phpMyAdmin combining the #_content
and #content_frontpage
tables called #__content_with_featured
.
I am now attempting to add a new column to this view. Ultimately, it will contain calculated data based on other values from columns in the view, but at this stage I can't even add the column. I get an error referencing the second line:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
ADD #_content_with_featured.f_current' at line 2
I have tried it with and without the view name. This is my SQL with the full new column name:
ALTER VIEW #_content_with_featured AS
ADD #_content_with_featured.f_current
What am I missing or doing wrong, please?