To create a View in phpMyadmin, you must first access phpMyadmin through cPanel.

1.  Click on a table, it is located on the left side, as the following image:

\
![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdVpPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--474455959246a74b052cae717e2234cc68c2190c/image%20(67).png)

2.  Then you click on "View".

1. Then "**Create View**".

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdWRPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--625d5771d497eb168c791c6ecf16253c81f58fe7/image%20(68).png)

3.  You will be presented with a form to insert some information to create the View, you must inform:

1. **View Name**

2. **Column Name** - Define the column names of the View, use commas to separate them.

3. **View Query** - which will select the values that the VIEW will return.


![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdWhPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--26025388bbc8eef0485743654d199d4fe67e0524/image%20(69).png)

1. After filling in the data click on "**Go**", and Views is ready.

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdXhPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0df90af91468e69ce339de5f72a86456c669ed70/image%20(70).png)