• 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

  • IT Goes Green, by the numbers
    In Media, System Administration, Talking Points, Tech Solutions
  • Apple Releases iOS5 Allowing iCloud to Operate
    In Hardware, Gadgets, and Products
  • Update for Adobe Reader/Acrobat 9.x Now Available
    In Security and Privacy, Software

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
  • Access to the resource [servershare] has been disallowed Access to the resource [servershare] has been disallowed
  • Read the Event Logs on Windows Server Core Read the Event Logs on Windows Server Core
  • Increase IIS Private Memory Limit to improve WSUS availability Increase IIS Private Memory Limit to improve WSUS availability
  • What is the AllJoyn Router Service on Windows 10? What is the AllJoyn Router Service on Windows 10?
  • Wal-Mart’s Low Tech Solution to a Shocking Problem Wal-Mart's Low Tech Solution to a Shocking Problem
  • How Virtual Reality Supports Mental Health Therapy How Virtual Reality Supports Mental Health Therapy
  • Key Strategies of Successful Coin Listing on Exchange Key Strategies of Successful Coin Listing on Exchange
  • Keeping Your Mac Healthy: A Comprehensive Guide to Maintenance and Troubleshooting Keeping Your Mac Healthy: A Comprehensive Guide to Maintenance and Troubleshooting
  • Making Distributed Software Development Work: Strategies and Best Practices for Managing Remote Teams Making Distributed Software Development Work: Strategies and Best Practices for Managing Remote Teams
  • customer contactless payment for drink with mobile phon at cafe counter bar,seller coffee shop accept payment by mobile.new normal lifestyle concept The Latest Innovations In Payment Technology
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

  • How Virtual Reality Supports Mental Health Therapy
  • Key Strategies of Successful Coin Listing on Exchange
  • Keeping Your Mac Healthy: A Comprehensive Guide to Maintenance and Troubleshooting

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 © 2025 · Magazine Pro Theme on Genesis Framework · WordPress · Log in