MySQL - 如何为列设置标签

Question

Consider this table

CREATE TABLE `tblstaff` (
`id` INT(20) NOT NULL AUTO_INCREMENT,
`firstname` VARCHAR(200) NOT NULL,
`lastname` VARCHAR(200) NOT NULL,
`email` VARCHAR(200) NOT NULL,
`password` VARCHAR(200) NOT NULL,
`theme` VARCHAR(200) NOT NULL,
`navbar` VARCHAR(200) NOT NULL,
`role` ENUM('admin','staff','super') NULL DEFAULT NULL,
`status` ENUM('Active','Suspended') NOT NULL,
`hash` TEXT NULL,
INDEX `PRIMARY_KEY` (`id`)
)COLLATE='latin1_swedish_ci' ENGINE=MyISAM AUTO_INCREMENT=12 ;

I need to set a label for each columns in the database so that the PHP script can read it using the command

SHOW FULL COLUMNS FROM tbl_name

This is exactly as the "comment" column where the user can put anything, but I do not wish to use the comment column.

For example,

firstname => 'First Name'
lastname => 'Last Name'
role => 'User Role'

Any idea how to accomplish this? Is there any built in option for this ?

Answer 1

You can create a view with the desired aliases for columns.