Better Gradualy

Just did create table for inventory database for IT Asset.

Create table for softwares installed on users Computer. License for those softwares between free, licensed, shareware or pirated. what I want for those field was choosed only without entry new informations.

Table creation with selection only is with enum (column definition), here my example:


mysql> create table software(no_sw int(3) auto_increment not null primary key, name_sw varchar(50) not null, version_sw varchar(5) not null, license_sw enum( 'free', 'paid', 'shareware', 'pirated') , no_hd int(3) not null, no_user int(3) not null);
Query OK, 0 rows affected (0.01 sec)

enum after column name without specify caracter of column.
ref link from mysql for enum.


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.