Python and MySQL
½üÀ´ÐèÒªÓÃPython¶ÔMySQLÊý¾Ý¿â½øÐвÙ×÷¡£Python¾ÃÎÅÆäÃû£¬Î´¼ûÆä“ÈË”£»Êý¾Ý¿âÔø¾ºÜ¸ß·Ö£¬ÔçÒÑ»¹¸øÏÈÉú£¬¸üÎÞMySQL¾Ñé¡£ÓÚÊÇÒ»ÇдÓÁ㿪ʼ£¬½è»úºÃºÃѧϰһ·¬¡£
PythonÕâ¸ö½Å±¾ÓïÑÔȷʵÃû¸±Æäʵ£¬ÓÃÁ˼¸Ìì±ãϲ»¶ÉÏËüÀ²¡£ºÜ¼ò½à£¬ºÜ·½±ã¡£ÒÔËõ¼õ×÷Ϊģ¿é·Ö¸î·û£¬¶ÁÆðÀ´ÉÍÐÄÔÃÄ¿¡£pythonµÄÄÚ½¨Êý¾ÝÀàÐÍ£¨list, tuple, dict£©ÒÔ¼°ÄÚ´æ¹ÜÀí»úÖÆÊ¹µÃ±äÁ¿µÄʹÓ÷dz£¼òµ¥£¬Ð´Æð´úÂëÀ´º¨³©ÁÜÀ죨µ±È»»¹ÊÇÓ¦¸Ã¶¯ÊÖǰ×Ô¸ö½øÐй滮µÄºÃ£©¡£
¹Ø¼üµÄ£¬PythonÒѾÁ÷ÐÐÁ˺ܾÃÀ²£¬¸÷ÖÖÄ£¿éºÜ¶àºÜÇ¿´ó¡£±ÈÈçÆäMySQL½Ó¿Ú¡£ÀûÓÃPython£¬ºÜÈÝÒ׵ľͽ«Ò»Ð©¸´ÔÓµÄSQL¹ý³ÌÖØÐÂʵÏÖÁË¡£ÊµÔÚ²»´í¡£
Êý¾Ý¿âÕâ±ßÖ÷Òª¸´Ï°ÁËϹØÏµÊý¾ÝµÄÏà¹Ø¸ÅÄÁ˽âһЩMySQLµÄ¾ßÌåÓï·¨ºÍÃüÁî¡£ÒòΪÖ÷ÒªÊDzÙ×÷£¬ÔÝʱ²»Éæ¼°Êý¾Ý¿âµÄÉè¼Æ£¬¾Í²»¶à˵ÁË¡£¸Ð¿®Ò»Ï£¬Êý¾Ý¿âÕæÊÇ»¥ÁªÍø¹«Ë¾µÄºËÐÄÖ®Ò»¡£
¼¸¸ö²»´íµÄ²Î¿¼Îĵµ£º
Python£º
¡¶PythonºËÐıà³Ì¡·
http://docs.python.org/tutorial/index.html
MySQL£º
¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡·
http://dev.mysql.com/doc/refman/5.1/zh/index.html
Python and MySQL£º
http://www.kitebird.com/articles/pydbapi.html
http://mysql-python.sourceforge.net/MySQLdb.html
Ïà¹ØÎĵµ£º
import this
The Zen of Python, by Tim Peters
Beautiful is better than ugly.
Explicit is better than implicit.
Simple is better than complex.
Complex is better than complicated.
Flat is better than nested.
Sparse is better than dense.
Readability counts.
Special cases aren't special enough t ......
from cmd import *
class MyShell(Cmd):
def preloop(self):
print "print this line before entering the loop"
def postloop(self):
&nb ......
1.PythonµÄÀ©Õ¹
PythonÀ©Õ¹ÊÇÖ¸ÔËÓÃÆäËûÓïÑÔ±àдijЩ¹¦ÄÜÄ£¿é£¬¹©Python³ÌÐòµ÷Ó㬳£ÓõÄÓÐPythonµÄCÀ©Õ¹ºÍC++À©Õ¹¡£PythonÀ©Õ¹µÄÄ¿µÄÖ÷ÒªÓÐÁ½¸ö£ºÒ»ÊÇΪÁ˹¦ÄÜÐèÒª£¬ÁíÍâÒ»¸öÔÒòÊÇΪÁËÐÔÄÜÐèÒª¡£ÏÂÃæ½éÉÜÒ»ÏÂÔÚ²»ÔËÓù¤¾ßµÄÇé¿öÏ£¬ÔËÓÃCºÍC++ÓïÑÔ¶ÔPython½øÐÐÀ©Õ¹µÄ²½Öè¡£
À©Õ¹µÄµÚÒ»²½ÊÇÓÃC»òC++´´½¨Ò»¸öÔ´³ÌÐò£¬È»ºó ......
Python , Delphi , Loki Èý¸öµ¥´ÊÓÐȤµÄÀ´Ô´
Ðí¶à³ÌÐòÉè¼ÆÓïÑԺͿª·¢¹¤¾ßÒÔ¼°¿âµÄÃû×Ö¶¼À´Ô´ÓëÉñ»°£¬ÆÄÓÐÒâ˼£º
°¢²¨ÂÞÊÇͬʱ³öÏÖÔÚÏ£À°ºÍÂÞÂíÉñ»°ÖеİÂÁÖÅÁ˹ʮ¶þ´óÉñÖ®Ò»¡£Ëû³ýÁËÓµÓÐÌ«ÑôÉñµÄÉí·Ö£¬Í¬Ê±»¹ÓÐÔ¤ÑÔ¡¢ÒÕÊõ¡¢Ò½ÊõÖ®ÉñµÄ³ÆºÅ¡£°¢²¨ÂÞÊÇÖæË¹ºÍÀÖ¶äµÄ¶ù×Ó£¬ºÍ°¢µÙÃÛ˹ÊÇË ......
½ñÌìÓöµ½Ò»¸öÒ»¸öÎÊÌ⣬Êǽ«×Ö·û´®ÀàÐ͵Äʱ¼äת»¯ÎªUTCʱ¼ä¡£ÀýÈçtime_str = "2009/11/09 12:23:23" ת»¯ÎªUTC intÐÍ¡£
ÕÒÁËһЩ×ÊÁÏ£¬·¢ÏÖtimeÄ£¿é¾ÍÄÜÍê³ÉÕâ¸öת»»¡£
import time
time_str = "2009/11/09 12:23:23"
time_s = time.strptime(time_str,"%Y/%m/%d %H:%M:%S")
utc_f = time.mktime(time_s)
utc_i = int ......