mysql

Mysql Views

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.

2 thoughts on “Mysql Views”

Leave a Reply

Your email address will not be published. Required fields are marked *

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