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

mysqlÇý¶¯Ñо¿Ö®Í¨ÓÃÊý¾Ýת·¢Æ÷

   Õâ¶Îʱ¼äÔÚѧϰC#,ÒªÁ¬½ÓmysqlÊý¾Ý¿â,²»ÖªµÀÔõôÁ¬½Ó ,ºóÀ´gooleÁËÏÂ,·¢ÏÖÒªÏÂÔØÇý¶¯,˳±ã¿´ÁËÏÂÁ¬½ÓµÄexample code
  ´úÂëºÍjavaÀïÃæµÄ²îºÜ¶à,֮ǰһֱÔÚѧC++ Ҳѧ¹ýÒ»¶Îʱ¼äµÄÇý¶¯¿ª·¢,Ò»ÌýmysqlÇý¶¯,ҲûÔÚÒâ, Çý¶¯ÔÚÐÄÀïÒ»Ö±¶¼ÊǺÜÄÑ
²¢ÇÒÈÝÒ×Ôì³ÉÀ¶ÆÁ,Êý¾Ý½á¹¹¸´ÔӵĴúÃû´Ê,Ò²¾ÍûÔÚÒâ,µ«ÊǺóÀ´ÔÚʹÓÃmysql.exe½øÐÐÃüÁîÐеǽµÄʱºò·¢ÏÖ´ËÇý¶¯·Ç±ËÇý¶¯
¾Í¾ö¶¨Ñо¿ÏÂ,¾õµÃmysql.exeÖ»ÊÇʹÓÃÌ×½Ó×ÖÁ¬½ÓÁË3306¶Ë¿Ú,È»ºó·¢ËÍÁËһЩÊý¾Ý È»ºóµÃµ½ÁËÁíÍâһЩÊý¾Ý,Òò´ËÖ»ÒªµÃµ½Í¨ÐŵÄЭÒé
¾Í¿ÉÒÔ×Ô¼ºÐ´³ö×Ô¼ºµÄmysqlÇý¶¯ ÉõÖÁÊÇÃâÇý¶¯µÄÊý¾Ý¿â²Ù×÷Èí¼þ,ËìÄÃÆðƽÈÕÀïÃæЭÒé·ÖÎöÀûÆ÷Ethernet À´¼àÌý3306¶Ë¿ÚÀ´ÍùµÄÊý¾Ý
°ü,ÉèÖÃfilterΪ tcp.port==3306 ,È»ºóÓÃmysql¿Í»§¶ËµÇ½ ,·¢ÏÖ¸ù±¾ÎÞ·¨µÃµ½ÈκÎÊý¾Ý,ºóÀ´»»¹ú²úµÄ¿ÆÀ´¾ÖÓòÍø×¥°ü¹¤¾ß
ͬÑùµÃ²»µ½Ê²Ã´Êý¾Ý,ºóÀ´
Sniffer,
Wildpackets Etherpeek ÂÖ·¬ÉÏÕó¶¼×¥²»µ½ÈκÎ3306¶Ë¿ÚµÄÊý¾Ý,µ«ÊÇ°ì·¨ÊÇÈËÏë
³öÀ´µÄ,ºóÀ´×Ô¼ºÐ´ÁËÒ»¸öͨÓõĶ˿ÚÊý¾Ýת·¢¹¤¾ß,×÷ΪÖмä´úÀíÖ»¼Ç¼ͨÐÅÊý¾Ý,Êý¾Ý²»×ö´¦Àí Ö±½Óת·¢.
   ÏÂÔصØÖ·:http://download.csdn.net/source/1914921


Ïà¹ØÎĵµ£º

mysql ´æ´¢¹ý³Ì ÓαêµÄÀý×Ó

create procedure getInfor2()
BEGIN
declare _abc varchar(200);
declare stopFlag int;
DECLARE cursor_name CURSOR
FOR
select zhuanyuan from server;
DECLARE CONTINUE HANDLER FOR NOT FOUND set stopFlag=1;
OPEN cursor_name;
REPEAT
FETCH cursor_name INTO _abc;
begin
if _abc='root'
the ......

[ÍƼö]MySQLÊý¾Ý¿âͼÐλ¯¹ÜÀí¹¤¾ßµÄʹÓÃ

×î½üÓõ½ÁËÒ»¿îÊý¾Ý¿âͼÐλ¯¹ÜÀí¹¤¾ßNavicat for MySQL £¬Ê¹ÓÃÖ®ºóÓÐÒ»Öָоõ£ºÔ­À´±à³Ì¿ÉÒԺܸßЧ£¡
ÒÔǰʹÓÃMySQLʱ£¬Ã¿´Î¶¼Ö»ÄÜÔÚÀàËÆDOSµÄ½çÃ濪·¢£¬Ê¹Óùٷ½ÌṩµÄ¹¤¾ßºÜÈÝÒ׾ͱ»¿¨µ½ÁË£¬¾õµÃ»¹ÊÇ×ÖÌõ½çÃæ±È½Ï¸ßЧ£¬µ«ÊdzõѧMySQL,ºÜ¶à¹¦Äܶ¼»¹Ã»ÓÐÍêÈ«Çå³þ£¬Ê¹Óð²È«ÐÔÉϵĿ¼ÂÇÒ²²»¹»³ÉÊì¡£ÕâʱºòÎÒ¿ ......

MySQLÖÐselect * for updateËø±íµÄÎÊÌâ


select * for updateËø±íµÄÎÊÌâ
ÓÉÓÚInnoDBÔ¤ÉèÊÇRow-Level Lock£¬ËùÒÔÖ»ÓС¸Ã÷È·¡¹µÄÖ¸¶¨Ö÷¼ü£¬MySQL²Å»áÖ´ÐÐRow lock (Ö»Ëøס±»Ñ¡È¡µÄ×ÊÁÏÀý) £¬·ñÔòMySQL½«»áÖ´ÐÐTable Lock (½«Õû¸ö×ÊÁÏ±íµ¥¸øËøס)¡£
¾Ù¸öÀý×Ó:
¼ÙÉèÓиö±íµ¥products £¬ÀïÃæÓÐid¸úname¶þ¸öÀ¸Î»£¬idÊÇÖ÷¼ü¡£
Àý1: (Ã÷È·Ö¸¶¨Ö÷¼ü£¬²¢ÇÒÓд˱Ê×ÊÁÏ£¬ ......

MySQL .Íâ¼üÔ¼Êø

InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
    REFERENCES tbl_name (index_col_name, ...)
    [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
    [ON UPDATE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ