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

¹ØÓÚmysqlÖд¥·¢Æ÷Ö´Ðж¯Ì¬sqlµÄÎÊÌâ

    Õ⼸ÌìÊÖÍ·¿ª·¢µÄϵͳҪ×öÒ»¸öÀàËÆwindowsÕË»§µ½ÆÚʱ¼äµÄ¹¦ÄÜ£¬¿¼ÂÇÁ˰ëÌìÏë³öÁËÒ»¸ö¼¼ÊõÉϺÍÂß¼­É϶¼»¹ÄÜʵÏֵĽâ¾ö·½°¸£º
´´½¨Ò»¸öÓû§´æÈëÊý¾Ý¿âµÄʱºò¶¼´´½¨Ò»¸öʼþµ÷¶ÈÆ÷À´¿ØÖÆÓû§µÄµ½ÆÚʱ¼ä£¨mysqlµÄʱ¼äµ÷¶ÈÆ÷ȷʵºÜ·½±ã£©¡£ÏëÆðÀ´ÊǺܼòµ¥£¬µ«ÊÇ×öÆðÀ´ÎÊÌâȷʵһ²¨½ÓÒ»²¨...
һЩСÎÊÌâ¾Í²»ËµÁË£¬µ½Á˹ؼüµÄµØ·½ÁË£ºÔÚ²åÈëÒ»¸öÓû§µÄʱºòÎÒµ½µ×ÊÇÔÚÓ¦ÓòãÀ´Ìí¼ÓÒ»¸öʼþµ÷¶ÈÆ÷ÄØ»¹ÊÇÔÚÊý¾Ý¿âÀïÃæ×Ô¶¯Ìí¼Ó¡£
µ±È»²»¹Ü´Ó´úÂëµÄÃÀ¹ÛÉÏ¡¢ÏµÍ³Éè¼ÆµÄ˼ÏëÉÏ»òÊÇÔËÐÐЧÂÊÉÏÀ´Ëµ£¬ÎÒ¶¼Ó¦¸ÃÑ¡ÔñºóÕߣ¨·Ï»°...£©¡£ÓÚÊÇÎÒ¾ÍÑ¡ÔñÁ˺óÕߣ¨Äã¸ÒÔÙ˵·Ï»°Â𣩡£ÄÇô¾ÍÓÐÁ˽ñÌìµÄÕâ¶Î±Ê¼Ç...
    Ò»¿ªÊ¼ÎÒÐËÖ²ª²ªµÄÆ´ºÃ×Ö·û´®Ê²Ã´µÄ£¬Ð´ÁËÈçÏÂÒ»¸ö´¥·¢Æ÷
delimiter //
create trigger tri_user after insert on user for each row
begin
set @u_name = new.u_name;
set @expire = '';
select sm_pwd_alter_day into @expire from system_manage where sm_id = 1;
set @str = concat('create EVENT eve_', @u_name, ' ON SCHEDULE EVERY ', @expire, ' day DO
update user set u_enable = \'δÆôÓÃ\' where u_name = \'', @u_name, '\'');
prepare stmt_str from @str;
execute stmt_str;
DEALLOCATE PREPARE stmt_str;
end;
//
delimiter ;
×Ðϸ¼ì²éÁËÓï·¨£¬È»ºóÐ˸߲ÉÁÒµÄÔËÐÐ...£¨orz£©½á¹ûÈ´ÊÇÏÂÃæÕâÐдíÎóÌáʾ£º
“Dynamic SQL is not allowed in stored function or trigger”
my god£¬Ô­À´mysqlµÄ´¥·¢Æ÷²»Ö§³Ö¶¯Ì¬sql£¬ÓÚÊÇÉÏÍøbaiduѰÕÒÌæ´ú·½·¨£¬ÎÞ¹û£¬
È»ºógoogle£¬·½·¨³öÏÖ£ºÓÐÈËÒ²Óöµ½ÁË´¥·¢Æ÷ÀïÖ´Ðж¯Ì¬sqlµÄÎÊÌ⣬Ȼºó·¢Ìû£¬ºóÃæ¸ßÊÖ½â´ð˵
°Ñ¶¯Ì¬sqlÓï¾ä´«Èë´æ´¢¹ý³ÌÀȻºóÔÚ´¥·¢Æ÷Àïµ÷Óô洢¹ý³Ì¾Í¿ÉÒÔÁË¡£È»ºóÄÇλ¥Ö÷»¹¸øÁ˸ßÊÖ
70·Ö£¨±¯¾ç,ºóÃæËµ£©...ÎÒÏëÕâ´Îµ½Î»ÁË¡£ÓÚÊÇÄ£·ÂÖ®¡¢ÓÚÊÇÔËÐÐÖ®¡¢ÓÚÊdzöÏÖ½á¹û£º
“Dynamic SQL is not allowed in stored function or trigger”
ÎÔ²Û...»¹ÊÇÕâ¸ö½á¹û...
ÓÚÊÇÎÒÃ÷°×Á˽áÁËÌùµÄÒ²²»Ò»¶¨ÊÇÕýÈ·´ð°¸¡£
ÄÇôÎÒÒÔΪ´æ´¢¹ý³ÌÀïÔËÐж¯Ì¬sql£¬È»ºó´¥·¢Æ÷ÔÙµ÷ÓÃÕâ¸ö´æ´¢¹ý³Ì£¬»¹ÊÇÏ൱ÓÚÔÚ´¥·¢Æ÷ÀïÔËÐж¯Ì¬sql¡£
²»ÏëÔÙÈ¥ÉÁË£¬»¹ÊÇÀÏÀÏʵʵÔÚÓ¦Óó̽â¾öÕâ¸öÎÊÌâÁË¡£


Ïà¹ØÎĵµ£º

mysql»ù±¾ÃüÁî

 Æô¶¯£ºnet start mySql;
  ½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
  ÁгöÊý¾Ý¿â£ºshow databases;
  Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
  Áгö±í¸ñ£ºshow tables£»
  ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
  ½¨Á¢Êý¾Ý¿â£ºsource fileNam ......

SQL Server2005 ±í·ÖÇøÈý²½Çú

ǰÑÔ
SQL Server 2005¿ªÊ¼Ö§³Ö±í·ÖÇø£¬ÕâÖÖ¼¼ÊõÔÊÐíËùÓеıí·ÖÇø¶¼±£´æÔÚͬһ̨·þÎñÆ÷ÉÏ¡£Ã¿Ò»¸ö±í·ÖÇø¶¼ºÍÔÚij¸öÎļþ×é(filegroup)Öеĵ¥¸öÎļþ¹ØÁª¡£Í¬ÑùµÄÒ»¸öÎļþ/Îļþ×é¿ÉÒÔÈÝÄɶà¸ö·ÖÇø±í¡£ÔÚÕâÖÖÉè¼Æ¼Ü¹¹Ï£¬Êý¾Ý¿âÒýÇæÄܹ»Åж¨²éѯ¹ý³ÌÖÐÓ¦¸Ã·ÃÎÊÄĸö·ÖÇø£¬¶ø²»ÓÃɨÃèÕû¸ö±í¡£Èç¹û²éѯÐèÒªµÄÊý¾ÝÐзÖÉ¢ÔÚ¶à¸ö·ÖÇøÖ ......

²é¿´sql server lock


 drop   table   #t  
  create   table   #t(req_spid   int,obj_name   sysname)   
  declare   @s   nvarchar(4000)   
  ,@rid   int,@dbname   sysname,@id   int,@objname   sysnam ......

SQLÓï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá

1. SQLÓÅ»¯µÄÔ­ÔòÊÇ£º
  ½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£  
  µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺  
  ¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ  
  ¼ì²é×Ó²éѯ   ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ