Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

Ïëд¸ömysqlµÄÅú´¦ÀíÎļþ°ï¿´¿´Ôõôд

±ÈÈçÏÂÃæµÄ´úÂë
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++Á¬½ÓMYSQLÊý¾Ý¿â£¬ÓÃADO·½·¨ÓÐûÓÐÒ»ÖÖ·½·¨²»ÓÃÉèÖÃÊý¾ÝÔ´£¿ÔõôŪ£¿Ð»Ð»¸÷λÁË
ÍøÉϽ̳̣¬ºÜ¶àµÄ £¬
VC ADO ·ÃÎÊ Êý¾Ý¿â

¹Ø×¢£¬
²»Ï²»¶ÉèÖÃÊý¾ÝÔ´£¬Âé·³£¬
¶øÇÒÈí¼þ°²×°ÔÚ±ðµÄ»ú×ÓµÄʱºò£¬ÊDz»ÊÇÒ²µÃÔÚÄÇ̨»ú×ÓÉÏÉèÖÃÊý¾ÝÔ´°¡£¬
ÒªÊÇÕâÑùµÄ»°£¬ÎÒÃÇÒªÈçºÎʵÏÖ×Ô¶¯ÉèÖÃÊý¾ÝÔ´£¬
Èç¹û²»Êǵϰ£¬ÓиÃÈ ......

SQL2000Á¬½Óµ½MySQLµÄÎÊÌ⣬¼±£¡

SQL2000Á¬½ÓMySQL£¬´úÂëÈçÏ£º
-- 2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC  sp_addlinkedserver    @server  =  'MySQLTest3 ',  @srvproduct= 'MySQL ',  @provider  =  'MSDASQL',  @datasrc  =  'myTest2 '
GO
EX ......

mysqlÈ¡×îиüÐÂÎÊÌâ

ÓÐ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×Ô¶¯±¸·Ý½Å±¾


ÎÒдµÃ½Å±¾£¬Ã¿´Î±¸·ÝÎÒµÄMySQLÊý¾Ý¿â£¬¾ÍÓÃÏÂÃæµÄ½Å±¾Íê³É¡£

/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*

@echo off
echo.
echo      MySQLÊý¾Ý¿â±¸·Ý

echo *****************************
echo.
echo ½ñÌìÊÇ %date%
echo ......

mysql ÈçºÎ½« Ã뻯Ϊ·Ö

ÈçÌ⣺
ÎÒÏë°ÑÒ»¸öµ¥Î»ÎªÃëµÄÊý»¯ÎªÒÔ·ÖÀ´ÏÔʾ£¬Õâ¸ö¸ÃÔõô×öÄØ£¿
¸ÕѧÊý¾Ý¿â£¬Çë¸÷λʦÐÖʦ½ãÖ¸½Ì~
лл~

ÒýÓÃ
ÈçÌ⣺
ÎÒÏë°ÑÒ»¸öµ¥Î»ÎªÃëµÄÊý»¯ÎªÒÔ·ÖÀ´ÏÔʾ£¬Õâ¸ö¸ÃÔõô×öÄØ£¿
¸ÕѧÊý¾Ý¿â£¬Çë¸÷λʦÐÖʦ½ãÖ¸½Ì~
лл~

лл߹
ÎÒ×Ô¼ºÐ´µÄÊÇ
ROUND(time/60,2)%60 as time,
......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [197] [198] [199] [200] 201 [202] [203] [204] [205] [206]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ