How to Create View in Mysql

| Last Updated: | In: Mysql


A view is a virtual table or mapping of data from one or more tables. Views do not contain any data – it is just a stored query in the database that can be executed when a view is called.

Purposes to Create a View

1) To focus, simplify, and customize the perception each user has of the database.
2) As a security mechanism by allowing users to access data through the view, for granting the users permissions to directly access the base table.
3) To provide a compatible interface to a table whose schema has changed.

mysql-views

SQL Statement for CREATE a VIEW

Below example will demonstrate to create view in mysql.

SQL SERVER Dropping a View

In below example i will explain a simple SQL statement to DELETE mysql views.

Do like & share with your friends if you like this post.

Tags: , , ,


About: Prem Tiwari

Prem Tiwari is the founder of freewebmentor.com and is a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby.


You may also like:

Get Free Access of 450+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Free Guide: Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Free WordPress Setup Service

Free WordPress Setup

Want to Setup WordPress Blog Setup? I will help you in the setup of your WordPress blog.

Click Here

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW