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Ö®¼äµÄÌìÊý
Ïà¹ØÎĵµ£º
1£® °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃ棬ȷ¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
download MySQL 5.0 Windows Installer
3£® & ......
OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â(1)
Oracle sql ÐÔÄÜÓÅ»¯µ÷Õû 1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a. RULE £¨»ùÓÚ¹æÔò£©
b. COST £¨»ùÓڳɱ¾£©
c. CHOOSE £¨Ñ¡ÔñÐÔ£©
ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶ ......
ÔÚOracleÖУ¬Èç¹ûÔÚsqlÖгöÏÖ'&'·ûºÅ£¬»á±»×Ô¶¯×ªÒ壻
¶ø±»ÒªÇóÊäÈëÔÚ&·ûºÅºó¸úËæµÄ×Ö·û´®µÄÖµ£¬ÀýÈ磺
update tablename set columnName='http://www.g.cn/cv2.jsp?spid=222&cid=333';
Ö´ÐÐÕâ¸ö²Ù×÷ʱ£¬Oracle»áÌáʾ
Enter value for cid:
ÔÒòÊÇÔÚOracleÖÐ & ·ûºÅÊÇ×÷ΪתÒå×Ö·ûʹÓõġ£
½â¾ö·½·¨ ......
°æȨÉùÃ÷
£º×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://bbayou.blogbus.com/logs/37045617.html
²âÊÔÊý¾Ý2.5G£¬¹²ÓÐÊý¾Ý9427567Ìõ¡£ÓõÄmysqlµÄlarge·þÎñÆ÷µÄÅäÖá£
load
Ò»´ÎÐèÒª´ó¸Å10·ÖÖÓ×óÓÒ¡£
½¨µÄ±íÓõÄÊÇMYISAM£¬µ÷ÕûÁ˼¸¸ösessionµÄ²ÎÊýÖµ
SET
SESSION
BULK_INSERT_BUFFER_S ......