ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿
ÇëÎÊÈçºÎ¸øMySQLÊý¾Ý¿â´«µÝDATETIMEÊý¾Ý£¿ÎÒÓõÄdate("Y-N-d H:i:s",time())²»ÐС£
SQL code:
mysql> desc t;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| dt | datetime | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
1 row in set (0.03 sec)
PHP code:
mysql_query("insert into t values('".date("Y-m-d H:i:s",time())."')");
×¢ÒâÈÕÆÚÀàÐͲåÈëÊý¾Ý¿âÖÐÒªÓÃ''À¨Æð¡£
ISO±ê׼ʱ¼ä¸ñʽ
2009-01-01 01:01:01
µ¥ÒýºÅÒýÆðÁ˵ģ¬ÈÔÈ»¶Á³öÀ´ÊÇ0000-00-00 00:00:00
¹ûÈ»ºÃÓÃ
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
windows xp·þÎñÖÐÆô¶¯mysql
Ìáʾ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯mysql·þÎñ
´íÎó3 ϵͳÕÒ²»µ½Ö¸¶¨Â·¾¶
cmdÀïÔËÐÐ
error 2003:Can't connect to MySQL ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......