Home > Database > mysql > Mysql Views


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.

2 Responses

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.