Mysql whileÑ»·Óï¾äÉú³É²âÊÔÊý¾Ý
ʹÓÃwhileÑ»·Óï¾äÉú³É²âÊÔÊý¾Ý£º
ÏÂÃæµÄ·½·¨ÊÇͨ¹ý´´½¨Ò»¸ö´æ´¢¹ý³Ì£¬È»ºóÔÙµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÀ´ÊµÏֵ쬴ÓÍøÉÏÕÒÁ˺ܶ෽·¨£¬µ«¶¼Ã»Óгɹ¦¡£
delimiter // /*¶¨ÒåÃüÁî½áÊø·ûĬÈÏΪ ; */
create procedure genUsers()
begin
declare i int default 0;
while i < 40 do
insert into users(userID,userName,password) values(i,concat('username',i),concat('password',i));
set i = i + 1;
end while;
end
//
Éú³ÉÕâ¸ö´æ´¢¹ý³Ìºó£¬Ë¢ÐÂϾÍÄÜ¿´µ½£¬È»ºóÖ±½Óµ÷ÓþͿÉÒÔÁË¡£
call genUser();
×¢ÒâÒªÊǸô洢¹ý³ÌÒÑ´æÔڵϰ£¬Ò»¶¨ÒªÏÈɾ³ýÖ®ºóÔÙÉú³É¡£
Ïà¹ØÎĵµ£º
ÕâÀïÊÕ¼¯¸÷ÖÖMysqlµÄ»ù´¡ÖªÊ¶,ΪÁËijЩ³¡ºÏµÄÐèÒª,»¹ÊÇÉáÆúnavicatÖ®ÀàµÄ¹¤¾ß¹Ô¹ÔÓÃÃüÁîÐаÉ
£¨×¢ÒâÓеÄÃüÁîÐèÒª·ÖºÅÓеIJ»ÐèÒª)
Ò».»ù±¾²Ù×÷
1.怬
mysql -u Óû§Ãû -pÃÜÂë Êý¾Ý¿âÃû
ÕâÀïÐè ......
ÅäÖø´ÖÆ
1.ÅäÖÃserver-idºÍlog-bin
2.Ö÷¿âÖÐÌí¼ÓÓÃÓÚ¸´ÖƵÄÓû§
GRANT REPLICATION SLAVE,reload,super ON *.*
TO 'repl'@'%.vm.dba.com' IDENTIFIED BY 'slavepass'
3.ÔÚ´Ó¿âÉÏÉèÖÃÓÃÓÚ¸´ÖƵÄÑ¡Ïî
server-id
master-host
master-user
master-password
--read-only ¸ÃÑ¡ÏîÈôӷþÎñÆ÷Ö»ÔÊÐíÀ´× ......
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON bankaccount.*
-> TO 'custom'@'localhost'
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INS ......
µ±ÄãÔËÐÐmysql commond line clientºó£¬»á¿´µ½Ìáʾ·û
ÊäÈëÃÜÂëºó½øÈëÈçÏÂÒ³Ãæ
ÕâÑùÄã¾Í¿ÉÒÔÔÚÕâ¸öDOS¿òÀïÊäÈëSQLÓï¾ä£¬Ö´ÐÐÁË¡£
1 ´´½¨Êý¾Ý¿âÃüÁî
ÔÚ´´½¨Êý¾Ý¿â֮ǰ¿ÉÒÔÊÇÓÃÃüÁî
show databases;
²é¿´ÓÐÄÇЩÊý¾Ý¿â£¬ÈçÏÂͼ
³õѧÕßÔÚÊäÈëÕâ¸öÃüÁîµÄʱºò»á¾³£Íü¼ÇDATABASESµÄ×îºóÒ»¸öS£¬¿ÉÒÔÏëÏñÔÚÊý¾Ý¿âÈí¼þÖв»Ö¹ ......
È¡µÃÎÄÕ¹ؼü×ÖΪkeywords
±ínewsµÄ¹Ø¼ü×Ö×Ö¶ÎΪkeyword
keywords=keywords.replace(',','|');
String sql="SELECT * from news WHERE keyword REGEXP '"+keywords+"' ORDER BY id ";
ÓÉÓÚijЩÔÒò£¬ÓÐʱºòÎÒÃÇûÓа´ÕÕ·¶Ê½µÄÉè¼Æ×¼Ôò¶ø°ÑһЩÊôÐԷŵ½Í¬Ò»¸ö×Ö·û´®×Ö¶ÎÖС£±ÈÈç¸öÈËÐËȤ£¬ÓÐʱºòÎÒÃÇÉè¼Æ±íΪ
cr ......