Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

phpÓëmysqlÔõôÅäÖÃ

ÎÒ¸ÕŪºÃÁË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µÄÖ¸¶¨¼Ç¼

ÈçÉÏ
phpÈç¹û»ñÈ¡mysql±í¼Ç¼µÄÖ¸¶¨ÐÅϢѽ£¿
±ÈÈçÏëÒª»ñÈ¡±ítableµÄpw_num×ֶεļǼ·Ö±ðΪ0£¬11£¬8£¬3£¬9
Ôõô²ÅÄÜ»ñµÃ×Ö¶Îpw_numÀïÃæ´óÓÚ5µÄֵѽ£¿£¨11£¬8£¬9£©

Çë¸ßÊÖ°ïæ½â¾öÒ»ÏÂ
лл

Òý ......

¹ØÓÚphpÁ¬½ÓÊý¾Ý¿âmysqlÎÊÌâ

ÎÒÏÖÔÚphp´úÂëÔÚwebÀï¶¼ÄÜÔËÐÐÆðÀ´ php apache¶¼ÅäÖúÃÁË
Á¬½ÓÊý¾Ý¿âÓýű¾Ò²ÄÜÔËÐÐ
ÔõôÓÃweb¾ÍÔËÐв»Á˰¡
ÓÃwebÔËÐв»ÁËʲôÒâ˼?web²»¾ÍÊÇphp½Å±¾Âð?

Òâ˼ÊÇrun as php script¿ÉÒÔ
µ«ÊÇÓà php web ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ