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.