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

MYSQL Ïà¹Ø

MYSQL where id inÎÊÌâ
SELECT * from product WHERE id IN (‘1522,1523,1524′)ORDER BY id DESC
ÔÚMYSQLÀïÃæÖ´ÐÐÕâ¸öÓï¾äÖ»·µ»Ø1522µÄÖµ¡£
Ö´ÐÐ
SELECT * from product WHERE instr(‘1522,1523,1524′,id) ORDER BY id DESC
»òÕß
SELECT * from product WHERE instr(‘1522,1523,1524′,id)>0 ORDER BY id DESC


Ïà¹ØÎĵµ£º

×ÊÔ´ÍÆ¼ö Îå¸ö³£ÓÃMySQLͼÐλ¯¹ÜÀí¹¤¾ß

  À´Ô´:Ô¹ⲩ¿Í   ºËÐÄÌáʾ£ºMySQLµÄ¹ÜÀíά»¤¹¤¾ß·Ç³£¶à£¬³ýÁËϵͳ×Ô´øµÄÃüÁîÐйÜÀí¹¤¾ßÖ®Í⣬»¹ÓÐÐí¶àÆäËûµÄͼÐλ¯¹ÜÀí¹¤¾ß£¬ÕâÀïÎÒ½éÉÜÎå¸öÎÒ¾­³£Ê¹ÓõÄMySQLͼÐλ¯¹ÜÀí¹¤¾ß£¬¹©´ó¼Ò²Î¿¼¡£ MySQLÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternet ......

mysqlÎÊÌâ

ÖØ×°Ê±³öÏÖcould not start the service mysql error:0µÄ´íÎóʱ
ÔÚ¿ØÖÆÃæ°åÖÐÔËÐÐÌí¼Óɾ³ý³ÌÐò£¬½«mysqlÐ¶ÔØ;
Ð¶ÔØºó´ò¿ª×¢²á±í£¬²é¿´HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services ϵļüÖµ£¬Èç¹ûÓÐÏà¹Ømysql¼üÖµ(mysql¡¢mysqladmin)Ôòɾµô£¬¼´¿É;
ÖØÆô£¬½«mysqlµÄ°²×°²ÐÓàĿ¼ɾµô (²é¿´·þÎñ£¬´Ëʱ·þÎñÖÐÒÑû ......

c++µ÷ÓÃmysql½Ó¿ÚÒÔ¼°´æ´¢¹ý³Ì

      mysqlÔÚsdkÖÐΪcÓïÑÔÌṩÁËһЩ·ÃÎʽӿڣ¬ÎÒÃÇ¿ÉÒÔʹÓÃÕâЩ½Ó¿ÚÁ¬½Ó²¢·ÃÎÊmysqlÊý¾Ý¿â£¬µ±È»Ò²¿ÉÒÔµ÷ÓÃmysqlµÄ´æ´¢¹ý³Ì¡£
Àý×Ó£º
      Ê×ÏÈÏÂÔØmysqlµÄsdk£¬½âѹºÃÒÔºó£¬ÀïÃæ°üº¬Ò»¸öinclude,ºÍlibÎļþ¼Ð¡£ÎÒÃÇÔÚ×Ô¼ºµÄ¹¤³ÌÖаüº¬ÕâÁ½¸öÎļþ¼ÐµÄĿ¼£¬²¢Ç ......

mysql »¥ÎªÖ÷´Ó


grant replication slave on *.* to backup@192.168.188.128 identified by "123456"; 
grant replication slave on *.* to backup@192.168.188.8 identified by "123456"; 
service mysql stop
server_id = 1
log-bin = mysql-bin
log-error=mysql-error
master-host = 192.168.188.8
master-user = ba ......

mysqlµÄslow queryÖеÄÒ»¸öÏÖÏó

ÔÚmysqlµÄslow query logÖУ¬¿ÉÄÜ´æÔÚÀàËÆÕâÑùµÄÌØÊâ¼Ç¼£º
# Time: 100127 23:17:01
# User@Host: root[root] @  [127.0.0.1]
# Query_time: 18446744073709.351562  Lock_time: 0.000129 Rows_sent: 1  Rows_examined: 11030
SET timestamp=1264663021;
SELECT dummy.id AS dummy_id
from dummy&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ