• 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

  • Keybase embraces social networks for cryptography
    In Security and Privacy, Web
  • Apple event removes ports and adds Touch Bar to new MacBook Pro
    In Featured, Hardware, Gadgets, and Products
  • Windows 10 will be free for Raspberry Pi 2
    In Hardware, Gadgets, and Products, Operating Systems

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
  • SOLVED: “This modification is not allowed because the selection is locked.” SOLVED: "This modification is not allowed because the selection is locked."
  • 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
  • Access to the resource [servershare] has been disallowed Access to the resource [servershare] has been disallowed
  • 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
  • How Digital Technology Brought the Rise of the CMO   How Digital Technology Brought the Rise of the CMO  
  • How to Purchase Cryptocurrencies? How to Purchase Cryptocurrencies?
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

  • Keeping Your Mac Healthy: A Comprehensive Guide to Maintenance and Troubleshooting
  • Making Distributed Software Development Work: Strategies and Best Practices for Managing Remote Teams
  • The Latest Innovations In Payment Technology

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