zmiao - 博客园

2014年8月

改MAC地址

摘要： Google TMAC v6.Or click here 阅读全文

posted @ 2014-08-18 10:53 zmiao 阅读(119) 评论(0) 推荐(0)

odd or even?

摘要： public boolean isEven(int data){ if((data&1)== 0) return true; return false; }much faster than using % 阅读全文

posted @ 2014-08-15 05:59 zmiao 阅读(171) 评论(0) 推荐(0)

2014年4月

免费vpn：SoftEther VPN

摘要： Google it.注意下载2.0版的，不要下载最新版的。阅读全文

posted @ 2014-04-09 13:29 zmiao 阅读(43) 评论(0) 推荐(0)

2014年3月

HTML center tag

摘要： This text will be center-aligned.或者可以把一个div给center了，例如将一个html表格给center表格的代码阅读全文

posted @ 2014-03-16 15:28 zmiao 阅读(168) 评论(0) 推荐(0)

sphinx分域搜索【不】需要在conf文件中使用sql_field_string

摘要：请看sql_field_string的文档说明： # combined field plus attribute declaration (from a single column) # stores column as an attribute, but also indexes it as a full-text field # # sql_field_string = author我们不需要attribute属性，不用管。只要在sql_query中选出相应的column就行了，就可以在php中使用extended_query_mode来进行query了，相应... 阅读全文

posted @ 2014-03-15 08:17 zmiao 阅读(1152) 评论(0) 推荐(0)

python插入mysql新值

摘要： #Server Connection to MySQL:import MySQLdbconn = MySQLdb.connect(host= "localhost", user="root", passwd="newpassword", db="engy1")x = conn.cursor()try: x.execute("""INSERT INTO anooog1 VALUES (%s,%s)""",(188,90)) conn.commit()exce 阅读全文

posted @ 2014-03-13 12:53 zmiao 阅读(214) 评论(0) 推荐(0)

create a new table for the query results

摘要： http://stackoverflow.com/questions/2698401/how-to-store-mysql-query-results-in-another-tableCREATE TABLE another_table SELECT /your query goes here/多建几张中间过渡用的表，无所谓的。阅读全文

posted @ 2014-03-13 08:03 zmiao 阅读(154) 评论(0) 推荐(0)

sphinx query multiple indexes in php

摘要： http://stackoverflow.com/questions/17494784/searching-a-particular-index-using-sphinx-from-multiple-indexes-through-php-scfor one index$res = $cl->Query($query,"src1"); for multiple indexes$res = $cl->Query($query,"src1 src2 src3 src4"); 阅读全文

posted @ 2014-03-12 07:38 zmiao 阅读(224) 评论(0) 推荐(0)

mysql date range

摘要： http://stackoverflow.com/questions/9935690/mysql-datetime-range-query-issueSELECT * FROM util_audit WHERE `DATED` BETWEEN "2012-03-15" AND "2012-03-31"; 阅读全文

posted @ 2014-03-12 07:37 zmiao 阅读(404) 评论(0) 推荐(0)

python操作mysql

摘要： http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python1，下载MySQLdb:http://sourceforge.net/projects/mysql-python/files/2，如下python代码#!/usr/bin/pythonimport MySQLdbdb = MySQLdb.connect(host="localhost", # your host, usually localhost user="john", # 阅读全文

posted @ 2014-03-12 03:59 zmiao 阅读(158) 评论(0) 推荐(0)

公告