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

mysqlÀïÈçºÎµÃµ½¸ñÁÖʱ¼ä ?

ÈçÉÏ, ?

¿´±éÁËÊÖ²á, Ã²ËÆÃ»ÓÐÕâÑùµÄº¯Êý
SQL code:
mysql> select UTC_TIMESTAMP() ,now();
+---------------------+---------------------+
| UTC_TIMESTAMP() | now() |
+---------------------+---------------------+
| 2009-09-19 04:02:40 | 2009-09-19 12:02:40 |
+---------------------+---------------------+
1 row in set (0.00 sec)

mysql>


²»ÐоÍ×Ô¼º¼Ó¸öÊ±ÇøµÄСʱ¡£

ºÃÏñ²»ÊÇÕâ¸ö, ÏñphpÀïÄǸötime()

ÊÇ10λµÄintÊý×ÖµÄ,  UNIX ʱ¼ä´Á ,


ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

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

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

mysqlÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ