How to create a VIEW in phpMyAdmin?

How to create a VIEW in phpMyAdmin?

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:


2.  Then you click on "View". 
  1.  Then "Create View".


3.  You will be presented with a form to insert some information to create the View, you must inform: 
  1. View Name 
  1. Column Name - Define the column names of the View, use commas to separate them. 
  1.  View Query - which will select the values that the VIEW will return.


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



    • Related Articles

    • How to create Procedure in phpMyAdmin?

      To create a Procedure in phpMyadmin, you must first access phpMyadmin through cPanel. 1. Click on your database which is located on the left side, after that, click on "Routines". 2. Then click on "Create new Routine". 3. Fill in the data and ...
    • How to create a table in PhpMyAdmin?

      To create a table in phpMyadmin, you must first access phpMyadmin through cPanel.  - Click on the database you want to create the table, which is located on the left side; - Now click on "Create table", type the name of the table and the number of ...
    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...
    • JetBackup 5 - View Downloads : How to view download history

      Jetbackup 5 has a new interface, with better usability and new options, making it easier to search for specific items. In this article we will demonstrate how to view the download history in a cPanel account. First we must access cPanel and navigate ...
    • How to access PhpMyAdmin in your hosting?

      When hosting with Scriptcase, phpMyAdmin is already installed as standard, you just need to access it through cPanel. See how to access cPanel : Aqui phpMyAdmin is a SQL database manager where you can make changes to your database. - Through cpanel ...