±ÈÈçÏÂÃæµÄ´úÂë
d:
mysql -u zhongda -p
show slave status\G;
±£´æ³É.batµÄÎļþ
ÔËÐкó Ò»ÊäÈëÃÜÂë¾Í²»Ö´ÐÐ
show slave status\G;
ÎÒÏëÊäÍêÃÜÂëºó¼ÌÐøÖ´ÐÐ
show slave status\G;
ÒªÔõôд
cmd주
D:\>mysql -u zhongda -p -e "show slave status\G" > e:\test.ba ......
vc++Á¬½ÓMYSQLÊý¾Ý¿â£¬ÓÃADO·½·¨ÓÐûÓÐÒ»ÖÖ·½·¨²»ÓÃÉèÖÃÊý¾ÝÔ´£¿ÔõôŪ£¿Ð»Ð»¸÷λÁË
ÍøÉϽ̳̣¬ºÜ¶àµÄ £¬
VC ADO ·ÃÎÊ Êý¾Ý¿â
¹Ø×¢£¬
²»Ï²»¶ÉèÖÃÊý¾ÝÔ´£¬Âé·³£¬
¶øÇÒÈí¼þ°²×°ÔÚ±ðµÄ»ú×ÓµÄʱºò£¬ÊDz»ÊÇÒ²µÃÔÚÄÇ̨»ú×ÓÉÏÉèÖÃÊý¾ÝÔ´°¡£¬
ÒªÊÇÕâÑùµÄ»°£¬ÎÒÃÇÒªÈçºÎʵÏÖ×Ô¶¯ÉèÖÃÊý¾ÝÔ´£¬
Èç¹û²»Êǵϰ£¬ÓиÃÈ ......
SQL2000Á¬½ÓMySQL£¬´úÂëÈçÏ£º
-- 2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC sp_addlinkedserver @server = 'MySQLTest3 ', @srvproduct= 'MySQL ', @provider = 'MSDASQL', @datasrc = 'myTest2 '
GO
EX ......
ÓÐtab1£¬ÓÐ3ÁÐ
»õÎïÃû³Æ£¬½ñÌìµ½¶àÉÙ£¬Ë³Ðò
goodname,arrival_t,order
gd1,30,1
gd1,40,2
gd1,50,3
gd2,10,1
gd2,11,2
gd3,1,1
gd3,12,2
ÎÒҪȡÅÅÐò×î´óµÄgd£¬È¡³öÀ´µÄ½á¹û¼¯Ó¦¸ÃÊÇÕâÑùµÄ
gd1,50,3
gd2,11,2
gd3,12,2
²»ÖªµÀmysqlÓÃÒ»ÌõÓï¾äÔõôȡ£¬oracle¿ÉÒÔÓ÷ÖÇ ......
ÎÒдµÃ½Å±¾£¬Ã¿´Î±¸·ÝÎÒµÄMySQLÊý¾Ý¿â£¬¾ÍÓÃÏÂÃæµÄ½Å±¾Íê³É¡£
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
@echo off
echo.
echo MySQLÊý¾Ý¿â±¸·Ý
echo *****************************
echo.
echo ½ñÌìÊÇ %date%
echo ......
ÈçÌ⣺
ÎÒÏë°ÑÒ»¸öµ¥Î»ÎªÃëµÄÊý»¯ÎªÒÔ·ÖÀ´ÏÔʾ£¬Õâ¸ö¸ÃÔõô×öÄØ£¿
¸ÕѧÊý¾Ý¿â£¬Çë¸÷λʦÐÖʦ½ãÖ¸½Ì~
лл~
ÒýÓÃ
ÈçÌ⣺
ÎÒÏë°ÑÒ»¸öµ¥Î»ÎªÃëµÄÊý»¯ÎªÒÔ·ÖÀ´ÏÔʾ£¬Õâ¸ö¸ÃÔõô×öÄØ£¿
¸ÕѧÊý¾Ý¿â£¬Çë¸÷λʦÐÖʦ½ãÖ¸½Ì~
лл~
лл߹
ÎÒ×Ô¼ºÐ´µÄÊÇ
ROUND(time/60,2)%60 as time,
......