MYSQL¼ÆËãÁ½ÈÕÆÚ/ʱ¼äÖ®¼äÏà²îµÄÌìÊý,ÃëÊý...·ÖÖÓ
#Á½ÈÕÆÚ/ʱ¼äÖ®¼äÏà²îµÄÌìÊý£º¡¡
To_Days(end_time)-To_Days(start_time)¡¡
#Á½ÈÕÆÚ/ʱ¼äÖ®¼äÏà²îµÄÃëÊý£º¡¡
SELECT¡¡UNIX_TIMESTAMP(end_time)-¡¡UNIX_TIMESTAMP(start_time);¡¡
#Á½ÈÕÆÚ/ʱ¼äÖ®¼äÏà²îµÄʱ·ÖÊý£º¡¡
SELECT¡¡SEC_TO_TIME(UNIX_TIMESTAMP(end_time)-¡¡UNIX_TIMESTAMP(start_time));
×îºÃµÄ°ì·¨ÊÇÖ±½ÓÓÓ+”£¬“-” ¼ÆË㣬ĿǰµÄ°æ±¾¶¼Ö§³ÖÁË¡£
±ÈÈ磺SELECT * from Table_Name WHERE loginDate < NOW() -10 * 60;
(thismonth)תÌû£ºhttp://cdcxzw.blog.163.com/blog/static/4976841920095841651405/
Ïà¹ØÎĵµ£º
ÒòΪMySQLÔÙdebianÏÂĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ËùÒÔÐèҪעÊ͵ôÕâ¸öÏÞÖÆ¡£ÎÒµÄMySQLÊÇÓÃapt-get°²×°µÄ£¬ËùÒÔ·¾¶ÊÇĬÈϵģ¨Èç¹ûÊÇ×Ô¼º
ÊÖ¶¯°²×°£¬¿ÉÒÔ×Ô¼ºÑ°ÕÒÏÂÕýÈ·µÄ·¾¶£©£¬ÓÃÃüÁî vi /etc/mysql/my.cnf ´ò¿ªÎļþ£¬×¢Ê͵ô bind-address = 127.0.0.1 ±£´æ:wq »Ø³µ¡£
È»ºóÔٵǼµ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ ......
À´Ô´: ChinaUnix²©¿Í ¡¡ÈÕÆÚ£º 2008.04.28 12:29¡¡(¹²ÓÐ0ÌõÆÀÂÛ) ÎÒÒªÆÀÂÛ
ÊÇÓÃmysqlµÄʱºò£¬×Ö·û±àÂëÊǸö´óÎÊÌ⣬ÎÒһֱʹÓÃutf8µÄ±àÂ룬»ù±¾ÉÏûʲô´óÎÊÌ⣬¾ÍÊÇÿ´ÎÆô¶¯mysqlµÄʱºò¶¼ÐèÒªÉèÖÃһϣ¬mysql£¬Ê±¼ä³¤ÁË£¬Ò²¹ÖÂé·³µÄ£¬ÔÚÍøÉÏËÑÁËһϣ¬·¢ÏÖÏÂÃæµÄ·½·¨ÄÜÍêÈ«½â¾öÕâ¸öÎÊÌ⣬µ±È»Èç¹ûÊÇ×Ô¼º±àÒëµÄmy ......
netbeans6.7ÖÐÏòmysql5ÖвåÈëÖÐÎÄÊý¾ÝʱÏÔʾ”data too long for column“µÄÎÊÌâ¡£
ÎÒµÄmysqlÖÐ×Ö·ûµÄÉèÖÃʱutf-8£¬²¢ÇÒÔÚ¿ØÖÆ̨ÖпÉÒÔ²åÈëÖÐÎÄÊý¾Ý²¢ÏÔʾ£¬µ«ÔÚnetbeansÖвåÈëÊý¾Ýʱȴ×ÜÊÇÏÔʾ”data too long for column“¡£»ù±¾¿ÉÒÔÅжÏÊÇÓÉÓÚnetbeansºÍmysqlÖ®¼äµÄÊý¾Ý½»»»³öÁ ......
ÔËÐл·¾³£ºwindows xp sp2
IIS v5.1
PHP 5.3.1-Win32-VC9-x86
Mysql 5.0
°²×°²½Ö裺
°²×°IIS5.1
ÔÚ ......
Æô¶¯Mysql ´íÎó 1067 ½ø³ÌÒâÍâÖÕÖ¹µÄÒ»ÖÖ½â¾ö·½·¨
mysqld-nt --defaults-file=my.ini --standalone --console
²é¿´ÐÅÏ¢ÄÚÈÝ
·¢ÏÖMYSQL INNODB³õʼ»¯´íÎó¡£
´íÎóÈçÏ£º
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100115 10:14:04 InnoDB: Setti ......