2014 年 1月随笔档案 - 语辰

摘要：>>> import bsddb3>>> bsddb3.__file__'/usr/local/lib/python2.6/site-packages/bsddb3/__init__.pyc' 阅读全文

posted @ 2014-01-20 16:48 语辰阅读(255) 评论(0) 推荐(0)

IP：192.168.21.173 子网掩码：255.255.255.0 网关：192.168.21.2 DNS：8.8.8.8 8.8.4.4 1、设置IP地址、网关 ee /etc/rc.conf #编辑 ifconfig_em0="inet 192.168.21.173 netmask 255

摘要：IP：192.168.21.173子网掩码：255.255.255.0网关：192.168.21.2DNS：8.8.8.88.8.4.41、设置IP地址、网关ee /etc/rc.conf #编辑ifconfig_em0="inet 192.168.21.173 netmask 255.255.255.0" #设置IP地址，子网掩码defaultrouter="192.168.21.2" #设置网关hostname="FreeBSD" #设置主机名字esc 回车，再按a保存系统运维温馨提醒：qihang01原创内容版权所有,转载请注阅读全文

posted @ 2014-01-15 15:39 语辰阅读(3581) 评论(0) 推荐(0)

bit_count

摘要：bit_count函数的含义用来计算二进制数中包含1的个数。selectBIT_COUNT(10);因为10转成二进制是1010，所以该结果就是2。bit_or函数的含义就是对两个二进制数进行或运算。如： 1100或 0101-------------- 1101摘自：http://www.01happy.com/mysql-bit_count-bit_or/ 阅读全文

posted @ 2014-01-08 14:08 语辰阅读(227) 评论(0) 推荐(0)

SELECT s.* FROM person p INNER JOIN shirt s ON s.owner = p.id WHERE p.name LIKE 'Lilliana%' AND s.color <> 'white';

摘要：SELECT s.* FROM person p INNER JOIN shirt sON s.owner = p.idWHERE p.name LIKE 'Lilliana%'AND s.color 'white'; 阅读全文

posted @ 2014-01-08 13:45 语辰阅读(266) 评论(0) 推荐(0)

To find names containing exactly five characters, use “^”and “$”to match the beginning and end of the name, and five instances of “.”in between: mysql

摘要：To find names containing exactly five characters, use “^”and “$”to match the beginning and end of thename, and five instances of “.”in between:mysql> SELECT * FROM pet WHERE name REGEXP '^.....$';或者SELECT * FROM pet WHERE name REGEXP '^.{5}$'; 阅读全文

posted @ 2014-01-08 11:52 语辰阅读(225) 评论(0) 推荐(0)

alter table fx.pet modify column `species` varchar(20) binary;

摘要：alter table fx.pet modify column `species` varchar(20) binary; 阅读全文

posted @ 2014-01-08 11:51 语辰阅读(158) 评论(0) 推荐(0)

SELECT * FROM pet WHERE name REGEXP 'w';

摘要：To find names containing a “w”, use this query:SELECT * FROM pet WHERE name REGEXP 'w'; 阅读全文

posted @ 2014-01-08 11:46 语辰阅读(413) 评论(0) 推荐(0)

select * from pet where species regexp '^c';

摘要：select * from pet where species regexp '^c'; 阅读全文

posted @ 2014-01-08 11:31 语辰阅读(129) 评论(0) 推荐(0)

rollback

摘要：savepoint test;rollback to savepoint test; 阅读全文