mysql ´¥·¢Æ÷ÖÐnewºÍoldÓÐÉ¶Çø±ð£¿
Ò»°ãϰ¹ßÐÔµÄÓÃnewÀ´´úÌæcreate triggerÓï¾äÖÐONºó±ßµÄ±íÃû£¬µ«²»ÖªµÀʲôʱºòÓÃold,¸ü²»ÖªµÀÕâÁ½Õß¼äµÄÇø±ð£¡
delete,updateǰÓÃold;
insert,updateºóÓÃnew
old,new¶¼ÊÇ´ú±íµ±Ç°²Ù×÷µÄ¼Ç¼ÐС£
oldÊÇ´ú±íÒª²Ù×÷µÄ¸ü¸ÄǰµÄ¼Ç¼£¬newÊÇ´ú±íÒª²Ù×÷µÄ¸ü¸ÄºóµÄ¼Ç¼¡£
ѧϰÁË¡£¡£¡£¡£¡£
3Â¥£¬Õý½â¡£up
mysqlµÄ´¥·¢Æ÷ºÜÓÐÒâ˼
±ÈÈ統ǰ²åÈëÐеÄA=10,´¥·¢Æ÷ÀïÒªÐÞ¸ÄΪB£¬Ö»ÒªÔÚBEFORE INSERT ÀSET NEW.A=20,¾Í¿ÉÒÔÁË
µ«Ö»ÄÜÔÚBEFOREÀïʹÓÃNEW£¬AFTER²»ÐÐ
NEW ÊÇÐÂÖµ¡£
OLD ÊǾÉÖµ
INSERT Ö»ÓÐNEW
UPDATEÓÐNEWºÍOLD
DELETEÖ»ÓÐOLD
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......