|
| cool Statistics |
| | coolcommands: | 1338 | | Categories: | 83 | | Total queries: | 620138 | | Members: | 22813 |
|
|
|
|
 |
|
|
|
Search coolcommands.com
 |
Submitted by:
lvo |
coolcommand
how to create a table in mysql |
Description
To create a table in mysql:
mysql> create table users (username text not null,
-> password text not null,
-> primary key (username(8))); |
Example
create table users (username text not null, password text not null, primary key (username(8))); |
Return to search results
 | | | |
Random coolcommands
coolcommand: apropos - how to locate commands by keyword lookup
Example: apropos password
[show me the details] |
coolcommand: how to load a mysql database from a file to see warnings
Example: LOAD DATA INFILE '/tmp/INV_current.txt' INTO TABLE myapps.INV_current FIELDS TERMINATED BY ';' lines terminated by "\n" (bundle,server,type,name,version,description,tree);
[show me the details] |
coolcommand: how to create a mirror for swap in Solaris Volume Manager
Example: metainit d20 -m d21; vi /etc/vfstab; reboot; metattach d20 d22; swap -l
[show me the details] |
coolcommand: hostid - prints the numeric identifier of the current host
Example: hostid
[show me the details] |
|
|
coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts
| | | | |
|
|
|
|
 |
|
|
|
|
Top 5 Submitters
|
|---|
| lvo | 1160 |
| audet | 37 |
| kah00na | 32 |
| Mariom | 24 |
| lebjf000 | 14 |
Top 5 Searches
|
|---|
| Category Solaris | 51939 |
| Category AIX | 49006 |
| Category General UNIX | 47516 |
| solaris | 23554 |
| aix | 22739 |
|
|
|
|
Tuesday May 21, 2013
