unix commands & unix scripts @ coolcommands.com - the search engine for unix sysadmins

LVOware PRATTICO Consulting

Sunday May 27, 2012

Who's Online

Newest Member
beyondimagem

Hit Counter

9133552 Visitors

cool Statistics

Category Search coolcommands.com

Select Category:

	Submitted by: lvo
coolcommand how to create a table in mysql using a set
Description To create a table in mysql with uses a set: mysql> create table servers (hostname text not null, -> prd set("T","F") not null default "T", -> qlf set("T","F") not null default "T", -> dev set("T","F") not null default "T", -> test set("T","F") not null default "T", -> primary key (hostname(10)));
Example create table servers (hostname text not null, prd set("T","F") not null default "T", primary key (hostname(10)));

Random coolcommands

coolcommand: How do you know if your IBM AIX volume group is normal, big, or scalable
Example: lsvg myvg
[show me the details]

coolcommand: lscfg - display peripheral configuration on IBM RS/6000
Example: lscfg -pvl hdisk# | ent# | sys0
[show me the details]

coolcommand: vxmirror - how to mirror all the volumes on a disk in Veritas Volume Manager
Example: vxmirror rootdisk disk90
[show me the details]

coolcommand: sync - how to write i-node table and writes buffered to disk
Example: sync
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts