转:http://blog.csdn.net/k8080880/article/details/17392341
mysql> select sum(if(classid=1,1,0)) as blue,sum(if(classid=2,1,0)) as red from article;
+------+------+
| blue | red |
>查看详情
转:http://blog.csdn.net/dc_726/article/details/8576151/
1 show processlist;
SHOW PROCESSLIST显示哪些线程正在运行。您也可以使用mysqladmin processlist语句得到此信息。如果您有SUPER权限,您可以看到所有线程。否则,您只能看到您自己的线程(也就是,与您正在使用 >查看详情
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together wit >查看详情
# This is a basic VCL configuration file for varnish. See the vcl(7)
# man page for details on VCL syntax and semantics.
#
# Default backend definition. Set this to point to your >查看详情
cat test
#!/bin/bash
# chkconfig: - 90 10
# description: just a test
echo "Hello,$1"
mv test /etc/init.d/
chmod +x /etc/init.d/test
chkconfig --add test
service test start //可 >查看详情
#!/bin/bash
# Ping all the PC in a network segment
n=0
for (( i=1; i<255; i++ )) do ping -c1 -w1 $1.$i > /dev/null
if [ $? -eq 0 ]
then
echo "The $1.$i is Online"
n=$[$n+1]
else >查看详情
转:https://linux.cn/article-7723-1.html
root@raspberrypi:/home/pi# ls -rlht
total 36K
drwxrwxr-x 2 pi pi 4.0K Jan 27 2015 python_games
-rwxr-xr-x 1 pi &nb >查看详情
转:http://www.server110.com/mongodb/201403/7596.html
https://github.com/RickP/mongopi
MongoDB 2.1.1 for the Raspberry Pi - Work in progress!
Install the needed packages on Raspian: >查看详情