MySQLÁÙʱ±í½¨Á¢
MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GROUP BY article;
--²éѯÁÙʱ±íÊý¾Ý
SELECT article, dealer, price from shop, tmpWHERE shop.article=tmp.articel AND shop.price=tmp.price;
--UNLOCK TABLES;
DROP TABLE tmp;
Ïà¹ØÎĵµ£º
ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......
<!-- [if gte mso 10]>
MySQL5.1.x
°æ±¾ÖÐÒýÈëÁËÒ»ÏîÐÂÌØÐÔ
EVENT
£¬¹ËÃû˼Òå¾ÍÊÇʼþ¡¢¶¨Ê±ÈÎÎñ»úÖÆ£¬ÔÚÖ¸¶¨µÄʱ¼äµ¥ÔªÄÚÖ´ÐÐÌØ¶¨µÄÈÎÎñ£¬Òò´Ë½ñºóһЩ¶ÔÊý¾Ý¶¨Ê±ÐÔ²Ù×÷²»ÔÙÒÀÀµÍⲿ³ÌÐò£¬¶øÖ±½ÓʹÓÃÊý¾Ý¿â±¾ÉíÌṩµÄ¹¦ÄÜ¡£´Ë¹¦ÄÜÊǶÔ
Oracle
µÄ
Job/Schedule
µÄÄ£·Â£¬
5.1.X
°æ±¾ÒÔÉϲÅÖ§³Ö¡£
& ......
ÎÒ¾¹ýÕ⼸ÌìÑо¿·¢ÏÖmod_perlÌṩµÄ³ÖÐøÁ¬½Ó²¢²»ÖÇÄÜ£¨Ò²ÐíÊÇÎÒ»¹Ã»ÓÐÕÒµ½¸ü
ºÃµÄ½â¾ö·½°¸£©£¬Èç¹û½Å±¾ÖеIJÎÊýºÍ³õʼ»¯µÄ²ÎÊý²»Ò»Ñù£¬ÔÚÄÚ´æÖлá³öÏÖÁ½¸ö
¾ä±ú¡£
Apache::DBI->connect_on_init("DBI:mysql:mysql:localhost","root","root",
{
PrintError => 1,
RaiseError => 0,
AutoCommit => ......
http://hi.baidu.com/thinkinginlamp/blog/item/a352918fe70d96fd503d925e.html
2009Äê01ÔÂ12ÈÕ ÐÇÆÚÒ» ÏÂÎç 08:35
×÷ÕߣºÀÏÍõ
ÔÚÍøÉÏËæ±ãËÑËÑ£¬¾ÍÄÜÕÒµ½´ó°ÑµÄ¹ØÓÚMySQLÓÅ»¯µÄÎÄÕ£¬²»¹ýÀïÃæºÜ¶à¶¼²»×¼È·£¬Ëµ¸ö³£¼ûµÄ£º
SELECT a from ... WHERE b = ...
Ò»°ãÀ´Ëµ£¬ºÜ¶àÎÄÕÂ»á¸æ½ëÄãÀàËÆÕâÑùµÄ²éѯ£¬²»ÒªÔÚ“a ......