|
| cool Statistics |
| | coolcommands: | 1338 | | Categories: | 83 | | Total queries: | 620362 | | Members: | 22813 |
|
|
|
|
|
|
Search coolcommands.com
 |
Submitted by:
lvo |
coolcommand
how to limit the number of rows returned in mysql |
Description
To limit number of rows returned in mysql:
mysql> select * from tablename where type='abc' limit 2; |
Example
select * from tablename where type='abc' limit 2; |
Return to search results
 | | | |
Random coolcommands
coolcommand: mkcd - run a mksysb backup of a server without burning to cd or dvd in IBM AIX:
Example: /usr/sbin/mkcd -I /mksysb -e -R -S -L
[show me the details] |
coolcommand: kernel processes for IBM AIX
Example: ps -kl; pstat -a
[show me the details] |
coolcommand: how to test if an integer variable is greater than another integer variable in a shell script
Example: test $int1 -gt $int2; [ $int1 -gt $int2 ]
[show me the details] |
coolcommand: how to check the current corefile limit in Linux
Example: ulimit -c
[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 | 51966 |
| Category AIX | 49058 |
| Category General UNIX | 47586 |
| solaris | 23554 |
| aix | 22739 |
|
|
|
|
Saturday May 25, 2013
