Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·ÖÇø±í·¾¶ÉèÖõÄÎÊÌâ

ÔÚÍøÉÏ¿´µ½½éÉÜ·ÖÇø±íµÄÎÄÕÂ
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 ......

mysql ²éѯÖÐË÷ÒýµÄ¹ÖÎÊÌâ

SQL code:
explain select * from t_user where username like '%ÅÖ';

½á¹û:
+----+-------------+--------+-------+---------------+------------+---------+------+------+-----------------------
| id | select_type | table  | type  | possible_keys | key        | key_ ......

¹ØÓÚʹÓÃÊÓͼȡ²»µ½¼Ç¼(Êý¾Ý¿âʹÓÃmysql)

  ÔÚphpadminÖн¨Á¢ºÃÁËÒ»¸öÊÓͼroute1,È»ºóµã»÷SQL£¬ÊäÈëÓï¾ä£º
  select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó';
  ÔËÐÐͨ¹ý£¬·µ»ØÒ»Ìõ¼Ç¼¡£
  ÏÖÔÚÎÒÏëÓô«²ÎÊýµÄ·½Ê½£¬ÔÚÒ³Ãæ±àдʼþʵÏÖ¶¯Ì¬²éѯ£¬ÎÊÌâÊǼ´±ãÓõÄÊǾ²Ì¬²éѯ·½Ê½£¬»¹ÊÇÈ¡²»µ ......

MySql·þÎñÎÞ·¨Æô¶¯£¬´íÎó1067£¡¼±ËÀÎÒÁË£¡

°²×°Ê±×Ö·û¼¯ÉèÖõÄlatin1£¬ÓÃMyFrontµ¼³öÀ´ºóÂÒÂëÁË£¬ÓÚÊÇÖØÐÂÉèÖÃ×Ö·û¼¯£¬½á¹ûmysql·þÎñÔõôҲÆô¶¯²»ÆðÀ´ÁË£¬ÀïÃæ¶¼Êǹ¤×÷Êý¾Ý£¬Ôõô»Ö¸´°¡£¬¼±ËÀÁË£¡
¼ì²éһϴíÎóÐÅÏ¢ÊÇʲô£¬Ìù³öÀ´£¬ÕâÑù´ó¼Ò¿ÉÒÔ½øÐзÖÎö¡£


°Ù¶È ²éÏ mysql 1067 ×Ô¼º¿´¿´¾ÍÖªµÀÁË

Ïêϸµã°É¡£ ÂÒÂëÎÊÌâÂÛ̳½â¾öÌ«¶àÁË¡£
1. ¿ÉÒÔ½â¾ö¡£ ......

¹ØÓÚ asp.net Á¬½Ó mysql ÎÊÌ⣿

ÎÒ֮ǰûÓÐÓùýmysql ÏÖÔÚÐèҪʹÓã¬ÓÃasp.netÁ¬½Ómysql ÊDz»ÊÇÐèÒª°²×°Connectors /net  °¡ 
µ«ÊÇÎÒÏÂÔØÊ±ºò·¢ÏÖÖ»ÓÐ32λµÄ  ÎÒµÄϵͳÊÇ64λµÄ ÄÜÓÃÂð£¿

¸øÎÒ˵˵ߣ¿Ð»Ð»ÁË£¡

Ò»°ã64λ¶¼ÄܼæÈÝ32λµÄ³ÌÐò

<span style="color:#FF0000">ÐèÒªÏÂÔØMySql.Data.dll </span&g ......

mysqlÈ«ÎÄË÷Òý

СµÜÔÚ×ö¸öÍøÕ¾£¬ÏÖÔÚÅöÉϸöÌÌÊÖµÄÎÊÌâ!¶Ô·½¸øÁ˼¸GµÄwordÎĵµ×ÊÁÏ£¨ÎĵµÖаüº¬Í¼Æ¬£©£¬×÷ΪËÑË÷×ÊÁÏ£¡ÎÒÔ­±¾ÊǰÑ×ÊÁÏ´æ·ÅÔÚ´ÅÅÌÉÏ£¬Êý¾Ý¿âÖÐÖ»´æ·ÅÎĵµµÄ·¾¶ºÍÃû³Æ¡£ÕâÑù¾ÍºÜÈÝÒ׸㶨£¡
²»¹ý×òÍí£¬¶Ô·½Í»È»ÒªÇóЧ¹ûÒª×öµ½Ïñ°Ù¶È°Ù¿ÆÄÇÑù£¡¾ÍÊÇÎÄÕÂÖгöÏÖµÄһЩ¹Ø¼ü´ÊÒª×Ô¶¯²úÉú³¬Á´½Ó¡£¾ÍÏñÎÒÃÇÔÚ¿´NBAÎÄÕÂʱ£¬ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [44] [45] [46] [47] 48 [49] [50] [51] [52] [53]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ