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

mysqlʱ¼ä´Á - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÏÖÔÚÎÒµÄmysqlÔÚlinuxÏÂÅÜ£¬µ«ÊÇËüµÄÆðʼʱ¼ä×ֶκÍ×îºóʱ¼ä×ֶζ¼ÊÇutc ʱ¼ä´Á£¬ÄÇÎÒÔõôÅжÏÁ½ÕßÖ®¼äʱ¼äÖ®²îСÓÚ5·ÖÖÓÄØ£¿


ÎÒoutÁË :-)

LSµÄÐÖµÜÃǶ¼ÊǸßÊÖ¡£

ÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡

ÒýÓÃÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡
¹À¼ÆÄãд´íÁË¡£

ÍêÕûµÄ¸´ÖÆÌù³öÄãµÄÓï¾äºÍ´íÎóÐÅÏ¢¡£

²»ºÃÒâ˼£¬ÎÒ½¨ÁËÒ»ÕűíÔËÐÐÊÇÕý³£µÄ£¬µ«ÎÒÃÇÓõÄÕâ¸öÈí¼þÊÇÔÚmysql»ù±¾ÉÏ·â×°Á˵ģ¬ËùÒÔÏñinterval ÕâÖֹؼü×ÖºÃÏñ²»ÊǺÜÖ§³Ö£¬²»ÖªµÀÓÐûÓÐÁíÒ»ÖÖд·¨£¿±Ü¿ªÕâÖֹؼü×ÖµÄÄÇÒ»ÖÖ£¿

Äܲ»ÄÜÖ±½Ódate2-date1 > 5 ÕâÑùд£¿


Ïà¹ØÎÊ´ð£º

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

myeclipse+mysqlµÄÅäÖÃÎÊÌâ - Java / Eclipse

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......

Ò»¸ömysqlÖйØÓÚin×Ó²éѯµÄÎÊÌâ - Java / Web ¿ª·¢

SELECT * from alarms where id in (select resource_id from res_products where product=22)
Õâ¸öÓï¾äÔÚmysqlÖÐΪʲô²»ÄÜÖ´ÐУ¿ÎÒµÄmysqlÊý¾Ý¿âÊÇ5.0.27°æ±¾µÄ£¡
Èç¹ûʵÔÚ²»ÐÐÄÇô¸ÃÓøöʲôÓï¾ä´úÌæÐ§Âʸü¸ßÄØ ......

mssqlº¯Êý·­Òë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¹òÇó½«ÒÔϺ¯Êý·­ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd( 
@date datetime, --»ù´¡ÈÕÆÚ 
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý 
)RETURNS datetime 
AS 
BEGIN 
DEC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ