mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ
select time from table
time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15
Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
2009-09-12 15ʱ
Ôõôֱ½ÓÁ¬½Ó£¿select time+¡®Ê±¡¯ from table ÕâÑù²»ÐÐ
½â¾öÁË¡£¡£¡£select DATE_FORMAT(time,'%Y-%m-%d %Hʱ') from table
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¸ÕŪºÃÁËiis+php£¬fastcgiÅäÖá£ÓÃphpinfo()²âÊԳɹ¦£¡
¶ømysql¾Í²»ÐÐÁË¡£ÎÒµÄiis ÊÇ7.5 php ÊÇ5.2.11 mysql ÊÇ5.0µÄ
ÐèÒªÔÚPHP.INIÖУ¬¿ªÆôphp_mysql.dllÀ©Õ¹¡£
ÎÒ×°µÄwamp+php£¬ÀïÃæµÄphp_mysql.dll¾ÍÊÇ¿ ......
ÈçÉÏ
phpÈç¹û»ñÈ¡mysql±í¼Ç¼µÄÖ¸¶¨ÐÅϢѽ£¿
±ÈÈçÏëÒª»ñÈ¡±ítableµÄpw_num×ֶεļǼ·Ö±ðΪ0£¬11£¬8£¬3£¬9
Ôõô²ÅÄÜ»ñµÃ×Ö¶Îpw_numÀïÃæ´óÓÚ5µÄֵѽ£¿£¨11£¬8£¬9£©
Çë¸ßÊÖ°ïæ½â¾öÒ»ÏÂ
лл
Òý ......
ÎÒÏÖÔÚphp´úÂëÔÚwebÀï¶¼ÄÜÔËÐÐÆðÀ´ php apache¶¼ÅäÖúÃÁË
Á¬½ÓÊý¾Ý¿âÓýű¾Ò²ÄÜÔËÐÐ
ÔõôÓÃweb¾ÍÔËÐв»Á˰¡
ÓÃwebÔËÐв»ÁËʲôÒâ˼?web²»¾ÍÊÇphp½Å±¾Âð?
Òâ˼ÊÇrun as php script¿ÉÒÔ
µ«ÊÇÓà php web ......