Home  >  Article  >  Backend Development  >  How to create a view in phpmyadmin

How to create a view in phpmyadmin

(*-*)浩
(*-*)浩Original
2019-10-14 09:23:095338browse

How to create a view in phpmyadmin

Log in to the phpmyadmin console, click "Database Management" on the left, and then click "MySQL Console" to log in using the database information. You can view the database information in "MySQL Management". (Recommended learning: PHP video tutorial)

Select your database and click "SQL"

How to create a view in phpmyadmin

Enter the SQL statement to create the view (Create View) in the SQL query box, how to click to execute it

How to create a view in phpmyadmin

You can also Enter a query statement in the SQL query box, and then execute it. Click "CREATE VIEW" on the execution result page to create a view

How to create a view in phpmyadmin

in a new window based on your view You need to select the corresponding option, enter the text, and then execute

How to create a view in phpmyadmin

The above is the detailed content of How to create a view in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn