mysql¶à±íÇå¿Õ
ÎÒÓжàÕÅ±í ·Ö±ðÊÇacid_event,tcphdr,event,data,iphdr ÏÖÔÚÒª¸öÅжÏÈç¹ûdataÖеÄSIDΪ1251µÄ»° ¾Í°ÑÉÏÃæµÄ¼¸ÕÅ±í¸øÇå¿Õµô Çå¿ÕҪͬʱ½øÐÐ
SQL code: delete from acid_event,tcphdr,event,data,iphdr where data.SID=1251;ÒýÓà SQL codedeletefrom acid_event,tcphdr,event,data,iphdrwhere data.SID=1251; ¿´Çå³þÁËÀ² ÊÇÇå¿Õ±í truncate? ÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐʵÏÖ£¬ÏÈÅжÏÌõ¼þ£¬È»ºóÇå¿ÕÏà¹Ø±í¡£ Èç¹û²»Ïë±£ÁôÈÕÖ¾¾ÍʹÓÃdeleteɾ³ý¶à±í¡£ ·ñÔò¾ÍʹÓÃtruncateÖð¸öÇå¿Õ¡£ ÒýÓà ÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐʵÏÖ£¬ÏÈÅжÏÌõ¼þ£¬È»ºóÇå¿ÕÏà¹Ø±í¡£ Èç¹û²»Ïë±£ÁôÈÕÖ¾¾ÍʹÓÃdeleteɾ³ý¶à±í¡£ ·ñÔò¾ÍʹÓÃtruncateÖð¸öÇå¿Õ¡£ ɾ³ýºÜÂý ËùÒÔÎÒÊÇ¿´Èç¹ûÕâ¶Îʱ¼ä¶¼Ã»Êý¾Ý²åÈëµÄ»° ÓÃidÈ¥ÅÐ¶Ï Ò»ÑùµÄ»° ¾ÍÓÃtruncateÇå¿Õ ÄãÄܼòµ¥µÄдÏÂÂð Â¥Ö÷µ½µ×ÏëʵÏÖʲô£¿ SQL code: mysql> select * from a1; +------+ | id | +------+ | 1 | | 2 | | 3 | +------+ 3 rows in set (0.00 sec) mysql> select * from a2; +------+ | id | +------+ | 1 | | 2 | | 3 | +------+ 3 rows in set (0.00 sec) mysql> select * from a3; +------+ | id | +------+ | 1 | |
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5 ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
mysql>create book( ->id varchar(20) not null,g -> ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷ ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......