Hi,
Following syntax is to create view in mysql.
One table user : id,fname,mname,lname,created_at
then create a table in the mysql
After that create a view.
Create or replace view user_view as select id, concat(fname,’ ‘,mname,’ ‘,lname),created_at from user;
Then it created a View.
You may like these posts
but use “replace” with caution,
its like this,
CREATE or REPLACE view as
create or replace view view_name as your_select_statement.