• Home
  • About 404TS
  • Contact

404 Tech Support

Where IT Help is Found

  • Articles
    • Code
    • Entertainment
    • Going Green
    • Hardware, Gadgets, and Products
    • Management
    • Network
    • News
    • Operating Systems
    • Security and Privacy
    • Software
    • System Administration
    • Talking Points
    • Tech Solutions
    • Web
    • Webmaster
  • Reviews
  • Media
    • Infographics
    • Videos
  • Tech Events
  • Tools
    • How do I find my IP address?
    • Browser and plugin tests
  • Get a Technical Consultation
You are here: Home / Articles / Webmaster / Creating and editing views in phpMyAdmin

Creating and editing views in phpMyAdmin

2012-04-12 by Jason

Using phpMyAdmin recently for a database project, creating a View wasn’t readily apparent. I eventually found it and it’s right where it needs to be if you know where to look.

Creating a MySQL view through phpMyAdmin

You can create a table from multiple places in phpMyAdmin but creating a view only comes after completing a SQL query.

Create your query against the database to verify that you are getting the desired columns and the correct rows. Then at the bottom of the results page, you will see a box for ‘Query results operations’. Click the link for ‘Create view’. (It’s boxed in red in the image below.)

This will take you to a new page with new fields to fill out. If you are creating a new view, you should fill out the ‘VIEW name’ field and you can use the ‘Column names’ field if you would like the column names to be different from their original names in the View. The query you ran will be copied into the ‘AS’ field and you can modify it if you wish. (I would advise getting it right when just doing queries for simplicity sake.) If you want their original names, leave the field blank. Hit ‘Go’ and your View will be created.

If you are wanting to edit a view, check the “OR REPLACE” box at top and fill in the ‘VIEW name’ field with the exact name of the View you are wanting to update. Hit ‘Go’ and your View will be updated.

Once you have a View in your database, it will be listed on the left-column (you might have to click the refresh button above for it to appear) along with your tables. Views, however, have a different icon. Instead of just the Table icon, they sport an eyeball on top of the table.

You can now use and edit your View at your convenience.

Filed Under: Webmaster

Trending

  • Amazon introduces new Kindles, Kindle Fires, and Fire OS
    In Hardware, Gadgets, and Products
  • AVG Reports Risks of Web Browsing by Country
    In Media, Security and Privacy, Tech Solutions
  • Dell uses closed-loop recycling for OptiPlex 3030 All-in-One
    In Infographics

Latest Media Posts

Find Out Where To Download SNES ROMs

Find Out Where To Download SNES ROMs

Multifunctional Video Conversion Tools – Wondershare Video Converter

Multifunctional Video Conversion Tools – Wondershare Video Converter

  • Popular
  • Latest
  • Today Week Month All
  • How to ‘Unblock’ multiple files at a time with PowerShell How to 'Unblock' multiple files at a time with PowerShell
  • Increase IIS Private Memory Limit to improve WSUS availability Increase IIS Private Memory Limit to improve WSUS availability
  • SOLVED: “This modification is not allowed because the selection is locked.” SOLVED: "This modification is not allowed because the selection is locked."
  • Configure Outlook to recurring appointments for the last weekday of the month Configure Outlook to recurring appointments for the last weekday of the month
  • Creating and editing views in phpMyAdmin Creating and editing views in phpMyAdmin
  • 3d rendering circuit cloud for cloud computing technology Build and Deploy a Modern Web 3.0 Blockchain App in 2022
  • Telecom Application Development: When to Outsource Telecom Application Development: When to Outsource
  • Printer printing document wirelessly from mobile phone or smartphone wifi connection vector flat cartoon illustration, file air print on fax or ink jet via cellphone bluetooth modern design Why Your Business Needs Online Fax Services In 2022
  • 6 Best Ways to Protect Your Business Account 6 Best Ways to Protect Your Business Account
  • How to download videos from Instagram How to download videos from Instagram
Ajax spinner

Elevator Pitch

404 Tech Support documents solutions to IT problems, shares worthwhile software and websites, and reviews hardware, consumer electronics, and technology-related books.

Subscribe to 404TS articles by email.

Recent Posts

  • Build and Deploy a Modern Web 3.0 Blockchain App in 2022
  • Telecom Application Development: When to Outsource
  • Why Your Business Needs Online Fax Services In 2022

Search

FTC Disclaimer

404TechSupport is an Amazon.com affiliate; when you click on an Amazon link from 404TS, the site gets a cut of the proceeds from whatever you buy. This site also uses Skimlinks for smart monetization of other affiliate links.
Use of this site requires displaying and viewing ads as they are presented.

Copyright © 2022 · Magazine Pro Theme on Genesis Framework · WordPress · Log in