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 founder of freewebmentor.com and Software developer from New Delhi (India). Follow Prem's development codes on facebook, and make sure you check out freewebmentor.com for the latest in web development related Tips with the complete code.


You may also like:

Follow us!

Get Free Access of 350+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Pincode Finder

pincode-finder tool

Online Pincode Finder

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

SEARCH NOW