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

oracleºÍmysqlÈÕÆÚº¯Êý¶Ô±È

MySQLÈÕÆÚ×ֶηÖDateºÍTimeÁ½ÖÖ£¬oracleÈÕÆÚ×Ö¶ÎÖ»ÓÐDate£¬°üº¬ÄêÔÂÈÕʱ·ÖÃëÐÅÏ¢£¬Óõ±Ç°Êý¾Ý¿âµÄϵͳʱ¼äΪsysdate,¾«È·µ½Ã룬»òÕßÓÃ×Ö·û´®×ª»»ÈÕÆÚÐͺ¯Êý£º
 
    To_date('2001-08-01','YYYY-MM-DD'); Äê-ÔÂ-ÈÕ
    24Сʱ£º·ÖÖÓ£ºÃëµÄ¸ñʽ  'YYYY-MM-DD HH24:MI:SS'  
  
MYSQL:
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
º¯Êý
¹¦ÄÜ
CURDATE()
·µ»Øµ±Ç°ÈÕÆÚ
CURTIEME()
·µ»Øµ±Ç°Ê±¼ä
NOW()
·µ»Øµ±Ç°Ê±¼äºÍÈÕÆÚ
UNIX_TIMESTAMP(date)
·µ»ØÈÕÆÚºÍUnixʱ¼ä´Á
from_UNIXTIME(datetime)
·µ»ØUnixʱ¼ä´ÁºÍÈÕÆÚÖµ
WEEK(date)
·µ»ØÈÕÆÚdateΪһÄêÖеڼ¸ÖÜ
YEAR(date)
·µ»ØÈÕÆÚdateµÄÄê·Ý
HOUR(time)
·µ»ØtimeµÄСʱֵ
MINUTE(time)
·µ»ØtimeµÄ·ÖÖÓÖµ
MONTHNAME(date)
·µ»ØdateµÄÔ·ÝÃû
DATE_FORMAT(date,fmt)
·µ»Ø°´×Ö·û´®fmtºÍ¸ñʽ»¯ÈÕÆÚdateÖµ
DATE_ADD(date,INTERVAL expr type)
·µ»ØÉÏÒ»¸öÈÕÆÚ»òʱ¼äÖµ¼ÓÉÏÒ»¸öʱ¼ä¼ä¸ôµÄʱ¼äÖµ
DATEDIFF(expr1,expr2)
·µ»ØÆðʼʱ¼äexprºÍ½áÊøʱ¼äexpr2Ö®¼äµÄÌìÊý


Ïà¹ØÎĵµ£º

ruby gem mysql on cygwin

1£®    °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃ棬ȷ¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
    ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
    download MySQL 5.0 Windows Installer
3£®  & ......

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â(1)
Oracle sql ÐÔÄÜÓÅ»¯µ÷Õû    1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
        ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a. RULE £¨»ùÓÚ¹æÔò£©  
b. COST £¨»ùÓڳɱ¾£©
c. CHOOSE £¨Ñ¡ÔñÐÔ£©
    ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶ ......

OracleµÄSQLÓï¾äÖÐÈçºÎ´¦Àí¡®&¡¯·ûºÅ

ÔÚOracleÖУ¬Èç¹ûÔÚsqlÖгöÏÖ'&'·ûºÅ£¬»á±»×Ô¶¯×ªÒ壻
¶ø±»ÒªÇóÊäÈëÔÚ&·ûºÅºó¸úËæµÄ×Ö·û´®µÄÖµ£¬ÀýÈ磺
update tablename set columnName='http://www.g.cn/cv2.jsp?spid=222&cid=333';
Ö´ÐÐÕâ¸ö²Ù×÷ʱ£¬Oracle»áÌáʾ
Enter value for cid:
Ô­ÒòÊÇÔÚOracleÖÐ & ·ûºÅÊÇ×÷ΪתÒå×Ö·ûʹÓõġ£
½â¾ö·½·¨ ......

ÈçºÎÌá¸ßmysql load data infileµÄËÙ¶È


°æȨÉùÃ÷
£º×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://bbayou.blogbus.com/logs/37045617.html
²âÊÔÊý¾Ý2.5G£¬¹²ÓÐÊý¾Ý9427567Ìõ¡£ÓõÄmysqlµÄlarge·þÎñÆ÷µÄÅäÖá£
load
Ò»´ÎÐèÒª´ó¸Å10·ÖÖÓ×óÓÒ¡£
½¨µÄ±íÓõÄÊÇMYISAM£¬µ÷ÕûÁ˼¸¸ösessionµÄ²ÎÊýÖµ
SET

SESSION

BULK_INSERT_BUFFER_S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ