Òì¹¹Êý¾Ý¿âÊý¾Ýͬ²½(´ÓProgressµ½MySQL)
Ò»Ö±Ïëдµã¶«Î÷£¬µ«È´³Ù³ÙûÓпªÊ¼£¬½ñÌìÎÞÒâÖлص½ERP100Õâ¸öÍøÕ¾£¬·¢ÏÖÓÐÁËQADµÄ×¨Çø£¬ÓÚÊÇ£¬Ò»Ê±ÈÈѪ·ÐÌÚ£¬Ð´Á˵㶫Î÷£¬¾Í½è´Ë»ú»á½«ÄÚÈÝÒ²·¢µ½ÕâÀï°É£¬ºÇºÇ¡£
ÆäʵÄÚÈݶ¼ÊDZ¾ÈËдµÄ£¬²»¹ýΪÁËͼ·½±ã£¬ÔÚERP100ÖÐдÍêÁË£¬È»ºóÖ±½ÓCopyµ½ÕâÀ͵Á˵ãÀÁ£¬ºÇºÇ¡£
ÒÔÏÂÊÇÕýÎÄ£¬ÔÚERP100ÖеĵØÖ·ÊÇ
http://bbs.erp100.com/forum.php?mod=viewthread&tid=74269&page=1&extra=#pid438182
ÓÉÓÚСµÜ½Ó´¥QADÒ²Ö»Óж̶̼¸Äêʱ¼ä£¬Ä¿Ç°Ò²Ö»ÊǸոÕÈëÃŵIJËÄñ¼¶±ð£¬Ï£Íû½è´Ë»ú»áÓëÊìϤQADÈí¼þµÄǰ±²Ò»Æð½»Á÷£¬ºÇºÇ¡£
ÏîÄ¿Ãû³Æ£º
Òì¹¹Êý¾Ý¿âÊý¾Ýͬ²½(´ÓProgressµ½MySQL)
±³¾°½éÉÜ£º
ÎÒÏÖÔÚ¹«Ë¾Ê¹ÓõÄQAD°æ±¾ºÜÀÏ£¬ÊÇ85gµÄ£¬ÓÚÊÇ£¬ÒªÉý¼¶µ½eb2.1£¬µ«ÓÉÓÚÓкܶàË®¾§±¨±íÊÇÖ±½ÓÁ¬µ½QADºǫ́ȡÊýµÄ£¬¶øeb2.1¶ÔÁ¬½ÓÊýÏÞÖÆÔÚ1¸ö£¬Òò´Ë£¬¹«Ë¾¾ö¶¨½«QADµÄÊý¾Ýͬ²½µ¼Èëµ½MySQLÊý¾Ý¿âÖУ¬ÕâÑù£¬Ö»Òª½«Ë®¾§±¨±íµÄÁ¬½ÓÖØÐÂÖ¸ÏòMySQL£¬¾Í¿ÉÒÔÕý³£Ê¹ÓÃÁË¡£
ʵÏÖ˼·£º
ҪʵÏÖʵʱͬ²½£¬×îÖ±½ÓµÄ¾ÍÊÇ´¥·¢Æ÷ÁË£¬Í¨¹ýÔÚ´¥·¢Æ÷ÖзÖÎö¸÷×ֶεÄÖµ£¬Éú³ÉSQLÓï¾ä£¬²¢´æÈëÎı¾ÎļþÖУ¬È»ºó£¬¶¨ÆÚµ÷ÓÃÒ»¶ÎJava³ÌÐò£¬¶ÁÈ¡Îı¾ÖеÄSQLÓï¾ä£¬½«Êý¾Ý²åÈëMySQLÊý¾Ý¿âÖС£
×¢£ºµ±Ê±ÔÚÏîÄ¿·ÖÎö½×¶Î£¬Êµ¼Ê»¹ÓÐ1Ì×·½°¸£¬Ò²ÊÇͨ¹ý´¥·¢Æ÷¼Ç¼±»Ð޸ĵÄÊý¾Ý£¬È»ºóдÈëÒ»¸ö×Ô¶¨Òå±íµÄRaw×ֶΣ¬È»ºó£¬¶¨Ê±Ö´ÐÐÒ»¶ÎProgress³ÌÐò£¬½«ÐÞ¸ÄдÈëµ½MySQLÖУ¬µ«ÓÉÓÚÕâ¸ö·½°¸ÐèÒª¶àÕ¼ÓÃÒ»¸öLicence£¬Òò´Ë£¬×îÖÕ±»·ÅÆú¡£
ʵÏÖ·½·¨£º
1. ÉèÖÃTrigger
½øÈëData Dictionary(Êý¾Ý×Öµä)£¬µã Edit -> Modify Table£¬ÔÚµ¯³öµÄ´°¿ÚÖÐÊäÈëÒª½¨TriggerµÄ±íÃû£¬ÀýÈç pt_mstr£¬È»ºó£¬ÔÚÖ®ºóµÄ´°¿ÚÖУ¬ÔÚ×îÏÂÃæµÄ°´Å¥ÖпÉÒÔÕÒµ½ Trigger µÄ°´Å¥£¬½øÈ¥Ö®ºó¾Íµ½ÁËTriggerµÄÉèÖýçÃæÁË£¬ÕâÀïÎÒÃÇÖ÷ÒªÔÚ Write ºÍ Delete ÉÏÃæÉèÖÃ(Æäʵ£¬QADµÄ²Î¿¼ÊÖ²áÉϺÃÏñÊÇÍÆ¼öµÄReplication-Write ºÍ Replication-Delete£¬µ«µ±Ê±²âÊÔµÄʱºòºÃÏñÓеãÎÊÌ⣬Òò´Ë£¬Ã»ÓÐʹÓá£ÁíÍ⣬Create²»Óùܣ¬ÒòΪ£¬´¥·¢ÁËCreateÖ®ºóÒ»¶¨»á´¥·¢WriteµÄ)£¬ÔÚµÚÒ»¸öÀ¸Î»ÌîÈëTriggerÒªÖ´ÐеijÌÐò(Ò»°ãÒÔ.t½áβ)£¬½«ºóÃæµÄCRC¼ìÑéÉèÖÃΪno(·ñÔò£¬³ÌÐòÔÚÖ´ÐÐʱ»á±¨´í)£¬ÉèÖÃÍêºóµãF4Í˳ö£¬²¢ÔÚµ¯³öµÄ´°¿ÚÖеã»÷±£´æ£¬ÕâÑù£¬Trigger¾ÍÉèºÃÁË¡£
2. ±àдTrigger´úÂë
ÏÈ¿´ÏÂÃæµÄ´úÂ룺
TRIGGER PROCEDURE FOR WRITE OF PT_MSTR OLD BUFFER OLD_PT_MSTR./*ÐÞ¸ÄÊý¾ÝʱµÄTrigger*/
TRIGGER PROCEDURE FOR DELETE OF PT_MSTR./*ɾ³ýÊý¾ÝʱµÄ
Ïà¹ØÎĵµ£º
×î½üÔÚѧϰtomcat+mysql¿ª·¢web£¬ÔÚ°²×°ºÍÐ¶ÔØmysqlµÄ¹ý³ÌÖÐÓöµ½ÁËһЩÎÊÌ⣬ÕÛÌÚÁËÎҺü¸Ìì¡£ÔÚÕâÀï¸ø´ó¼Ò½ÌÒ»ÏÂÍêÕûµÄÐ¶ÔØmysqlµÄ¹ý³Ì¡£
ÓÐʱºò֮ǰ°²×°¹ýmysqlÐ¶ÔØºóÓÖÖØÐ°²×°µÄ¹ý³ÌÖУ¬°²×°ºÃµÄmysql½ø²»È¥£¬ÈÃÈ˾õµÃºÜÐÄ·³£¬×Ô¼ºÒÑ¾Ð¶ÔØÁË£¬ÖØÐÂ×°Á˺óΪʲô½ø²»È¥ÄØ¡·£¿£¿ ÔÒòÊÇ ......
1. Á¬½Ómysql:
mysqlbinmysql -hÖ÷»úµØÖ· -u Óû§Ãû £p Óû§ÃÜÂë
2.Í˳ömysql:exit
3. ÐÞ¸ÄÃÜÂë:
mysqlbinmysqladmin -uroot -p(oldpassword) password newpassword
4.Ôö¼ÓÓû§£º
Ìí¼ÓÒ»¸öÓû§test1 ÃÜÂëΪABC£»ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ,²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬Èë
mysq ......
Link from : http://www.5ilinux.com/blog/archives/000091.html
1.Ê×ÏÈÎÒÃǽ¨Á¢ÏàÓ¦µÄÓû§ºÍÓû§×é
groupadd -g 5500 ftpgroup
adduser -u 5500 -s /bin/false -d /bin/null -c "proftpd user" -g ftpgroup ftpuser
2.²Ù×÷Êý¾Ý¿â
mysql mysql -uroot -ppassword
create database ftpdb
grant select, upd ......
Ò»Ö±ÒÔΪmysqlËæ»ú²éѯ¼¸ÌõÊý¾Ý£¬¾ÍÓÃ
SELECT
*
from
`
table
`
ORDER
BY
RAND
() LIMIT
5
¾Í¿ÉÒÔÁË¡£
µ«ÊÇÕæÕý²âÊÔһϲŷ¢ÏÖÕâÑùЧÂʷdz£µÍ¡£Ò»¸ö15ÍòÓàÌõµÄ¿â£¬²éѯ5ÌõÊý¾Ý£¬¾ÓȻҪ8ÃëÒÔÉÏ
²é¿´¹Ù·½ÊֲᣬҲ˵rand()·ÅÔÚORDER BY ×Ó¾äÖлᱻִÐж ......
ÔÚÏò±íÖвåÈëÊý¾ÝµÄʱºò£¬¾³£Óöµ½ÕâÑùµÄÇé¿ö£º1. Ê×ÏÈÅжÏÊý¾ÝÊÇ·ñ´æÔÚ£» 2. Èç¹û²»´æÔÚ£¬Ôò²åÈ룻3.Èç¹û´æÔÚ£¬Ôò¸üС£
ÔÚ SQL Server ÖпÉÒÔÕâÑù´¦Àí£º
if not exists (select 1 from t where id = 1) insert into t(id, update_time) values(1, getdate()) else update t set update_time = getdate() where id = ......