Mysql: Comments in Fields

April 9, 2008 by  
Filed under So Much Data

I never really noticed that you could create comments in your mySQL fields until now. My co-worker recently upgraded one of the web servers to have phpMyAdmin – 2.11.5.1, and the forms made the “comment” field more visible to me.

Below is a very basic table for “locations.” This simple table is for demonstration purposes only. ;)

Mysql table in PHPmyAdmin
Click on the image for a zoomed in view.

(See Pink Bubble) See how the fieldname is linked? That means there’s a comment about that field.

(See Blue Bubble) To create a comment, click on the pencil icon to edit the field. When you click on it, you should see a page that looks like this:
Comments about Mysql Field
In the newest version of PHPmyAdmin, the form fields go downward instead of left to right. I like this way much better! Anyhow, just add in your comment (see the blue arrow) and hit save. Ta da, now you have comments in your mysql fields.

This is great when you work with more complex databases. And the developer that takes over your project will appreciate it. Of course, you can always use the “COMMENT” command in your msyql command statement, but isn’t this prettier? ;)

Go here for more information about the Information_Schema Columns.

Source:
phpMyAdmin is a great software that allows you to visually see your mysql databases.

Related Products:

HORI Nintendo Switch Split Pad Pro (Daemon X Machina Edition) Ergonomic Controller for Handheld Mode - Officially Licensed By Nintendo - Nintendo SwitchHORI Nintendo Switch Split Pad Pro (Daemon X Machina Edition) Ergonomic Controller for Handheld Mode - Officially Licensed By Nintendo - Nintendo SwitchA revolutionary way to play your Nintendo Switch! Enjoy the full-size controller experience in handheld mode with the HORI Split Pad Pro. Featuring fu... Read More >
Practical Electronics for Inventors, Fourth EditionPractical Electronics for Inventors, Fourth Edition

A Fully-Updated, No-Nonsense Guide to Electronics

Advance your electronics knowledge and gain the skills necessary to develop and construct ... Read More >

An introduction to electronicsAn introduction to electronicsElectronics is fundamental to modern life. Using an interactive website, videos, and easy-to-use electronic circuit design and simulation software the course will show how electronic devices and systems pervade everything we do, and teach some of the basic ideas.
Related Posts Plugin for WordPress, Blogger...