ÔÚÍøÉÏ¿´µ½½éÉÜ·ÖÇø±íµÄÎÄÕÂ
CREATE TABLE users (
uid INT UNSIGNED NOT NULL PRIMARY KEY,
name VARCHAR(30) NOT NULL DEFAULT '',
email VARCHAR(30) NOT NULL DEFAULT ''
)
PARTITION BY RANGE (uid) (
PARTITION p0 VA ......
SQL code:
explain select * from t_user where username like '%ÅÖ';
½á¹û:
+----+-------------+--------+-------+---------------+------------+---------+------+------+-----------------------
| id | select_type | table | type | possible_keys | key | key_ ......
ÔÚphpadminÖн¨Á¢ºÃÁËÒ»¸öÊÓͼroute1,È»ºóµã»÷SQL£¬ÊäÈëÓï¾ä£º
select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó';
ÔËÐÐͨ¹ý£¬·µ»ØÒ»Ìõ¼Ç¼¡£
ÏÖÔÚÎÒÏëÓô«²ÎÊýµÄ·½Ê½£¬ÔÚÒ³Ãæ±àдʼþʵÏÖ¶¯Ì¬²éѯ£¬ÎÊÌâÊǼ´±ãÓõÄÊǾ²Ì¬²éѯ·½Ê½£¬»¹ÊÇÈ¡²»µ ......
°²×°Ê±×Ö·û¼¯ÉèÖõÄlatin1£¬ÓÃMyFrontµ¼³öÀ´ºóÂÒÂëÁË£¬ÓÚÊÇÖØÐÂÉèÖÃ×Ö·û¼¯£¬½á¹ûmysql·þÎñÔõôҲÆô¶¯²»ÆðÀ´ÁË£¬ÀïÃæ¶¼Êǹ¤×÷Êý¾Ý£¬Ôõô»Ö¸´°¡£¬¼±ËÀÁË£¡
¼ì²éһϴíÎóÐÅÏ¢ÊÇʲô£¬Ìù³öÀ´£¬ÕâÑù´ó¼Ò¿ÉÒÔ½øÐзÖÎö¡£
°Ù¶È ²éÏ mysql 1067 ×Ô¼º¿´¿´¾ÍÖªµÀÁË
Ïêϸµã°É¡£ ÂÒÂëÎÊÌâÂÛ̳½â¾öÌ«¶àÁË¡£
1. ¿ÉÒÔ½â¾ö¡£
......
ÎÒ֮ǰûÓÐÓùýmysql ÏÖÔÚÐèҪʹÓã¬ÓÃasp.netÁ¬½Ómysql ÊDz»ÊÇÐèÒª°²×°Connectors /net °¡
µ«ÊÇÎÒÏÂÔØÊ±ºò·¢ÏÖÖ»ÓÐ32λµÄ ÎÒµÄϵͳÊÇ64λµÄ ÄÜÓÃÂð£¿
¸øÎÒ˵˵ߣ¿Ð»Ð»ÁË£¡
Ò»°ã64λ¶¼ÄܼæÈÝ32λµÄ³ÌÐò
<span style="color:#FF0000">ÐèÒªÏÂÔØMySql.Data.dll </span&g ......
СµÜÔÚ×ö¸öÍøÕ¾£¬ÏÖÔÚÅöÉϸöÌÌÊÖµÄÎÊÌâ!¶Ô·½¸øÁ˼¸GµÄwordÎĵµ×ÊÁÏ£¨ÎĵµÖаüº¬Í¼Æ¬£©£¬×÷ΪËÑË÷×ÊÁÏ£¡ÎÒÔ±¾ÊǰÑ×ÊÁÏ´æ·ÅÔÚ´ÅÅÌÉÏ£¬Êý¾Ý¿âÖÐÖ»´æ·ÅÎĵµµÄ·¾¶ºÍÃû³Æ¡£ÕâÑù¾ÍºÜÈÝÒ׸㶨£¡
²»¹ý×òÍí£¬¶Ô·½Í»È»ÒªÇóЧ¹ûÒª×öµ½Ïñ°Ù¶È°Ù¿ÆÄÇÑù£¡¾ÍÊÇÎÄÕÂÖгöÏÖµÄһЩ¹Ø¼ü´ÊÒª×Ô¶¯²úÉú³¬Á´½Ó¡£¾ÍÏñÎÒÃÇÔÚ¿´NBAÎÄÕÂʱ£¬ ......