yazilimweb tasarim
For Immediate Onsite or Remote Support Call: +254746505075 or 0735193167

How to create a view in mysql database

Date: June 22, 2019 Author: peter Category: MYSQL Comments: 0

This is a tutorial from Kogibay Technologies on how to create a view in mysql database.

Syntax for creating View in MySQL :

create view 'view_name_here' AS 'SQL_STATEMENT_HERE';

Example of view in MySQL database is given below by Kogibay Technologies DBMaster

In MySQL editor or console enter the following command to create view in MySQL:

create view select firstname,lastname,memberno from members;

Leave a Reply

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