Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. 
¿ ......

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

mysqlÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ