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();
×¢ÒâÒªÊǸô洢¹ý³ÌÒÑ´æÔڵϰ£¬Ò»¶¨ÒªÏÈɾ³ýÖ®ºóÔÙÉú³É¡£
Ïà¹ØÎĵµ£º
ÅäÖø´ÖÆ
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 ¸ÃÑ¡ÏîÈôӷþÎñÆ÷Ö»ÔÊÐíÀ´× ......
¶¨ÆÚά»¤ÄãµÄÊý¾Ý±í¡£
¹¤¾ß£ºmysqlcheck myisamchk
mysqlcheck¿Í»§¶Ë¿ÉÒÔ¼ì²éºÍÐÞ¸´MyISAM±í¡£Ëü»¹¿ÉÒÔÓÅ»¯ºÍ·ÖÎö±í¡£
mysqlcheckµÄ¹¦ÄÜÀàËÆmyisamchk£¬µ«Æä¹¤×÷²»Í¬¡£
Ö÷Òª²î±ðÊǵ±mysqld·þÎñÆ÷ÔÚÔËÐÐʱ±ØÐëʹÓÃmysqlcheck£¬¶ømyisamch ......
×¢Ò⣺mysqlÖеÄÓû§±äÁ¿µÄÉúÃüÖÜÆÚÊǻỰ¼¶µÄ£¬²»ÊÇÓï¾ä¼¶µÄ£¡
´æ´¢¹ý³Ì--------------------------------------------------
drop procedure if exists usp_simple;
delimiter //
create procedure usp_simple(in ip int, out op int, inout iop int)
begin
select count(*) into op from t1;
set op ......
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON bankaccount.*
-> TO 'custom'@'localhost'
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INS ......