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

whereÌõ¼þ¶Ômysql¶àÁÐË÷ÒýµÄʹÓÃ

      MySQLÊÖ²áÖп´µ½µÄ£¬¼Ç¼Ï¡£
      MySQL¿ÉÒÔΪ¶à¸öÁд´½¨Ë÷Òý¡£Ò»¸öË÷Òý¿ÉÒÔ°üÀ¨15¸öÁС£¶ÔÓÚijЩÁÐÀàÐÍ£¬¿ÉÒÔË÷ÒýÁеÄǰ׺(²Î¼û7.4.3½Ú£¬“ÁÐË÷Òý”)¡£
¶àÁÐË÷Òý¿ÉÒÔÊÓΪ°üº¬Í¨¹ýÁ¬½ÓË÷ÒýÁеÄÖµ¶ø´´½¨µÄÖµµÄÅÅÐòµÄÊý×é¡£
MySQL°´ÕâÑùµÄ·½Ê½Ê¹ÓöàÁÐË÷Òý£ºµ±ÄãÔÚWHERE×Ó¾äÖÐΪË÷ÒýµÄµÚ1¸öÁÐÖ¸¶¨ÒÑÖªµÄÊýÁ¿Ê±£¬²éѯºÜ¿ì£¬¼´Ê¹ÄãûÓÐÖ¸¶¨ÆäËüÁеÄÖµ¡£
¼Ù¶¨±í¾ßÓÐÏÂÃæµÄ½á¹¹£º
CREATE TABLE test (
    id INT NOT NULL,
    last_name CHAR(30) NOT NULL,
    first_name CHAR(30) NOT NULL,
    PRIMARY KEY (id),
    INDEX name (last_name,first_name)
);
      nameË÷ÒýÊÇÒ»¸ö¶Ôlast_nameºÍfirst_nameµÄË÷Òý¡£Ë÷Òý¿ÉÒÔÓÃÓÚΪlast_name£¬»òÕßΪlast_nameºÍfirst_nameÔÚÒÑÖª·¶Î§ÄÚÖ¸¶¨ÖµµÄ²éѯ¡£Òò´Ë£¬nameË÷ÒýÓÃÓÚÏÂÃæµÄ²éѯ£º
SELECT * from test WHERE last_name='Widenius';
 
SELECT * from test
    WHERE last_name='Widenius' AND first_name='Michael';
 
SELECT * from test
    WHERE last_name='Widenius'
    AND (first_name='Michael' OR first_name='Monty');
 
SELECT * from test
    WHERE last_name='Widenius'
    AND first_name >='M' AND first_name < 'N';
È»¶ø£¬nameË÷Òý²»ÓÃÓÚÏÂÃæµÄ²éѯ£º
SELECT * from test WHERE first_name='Michael';
 
SELECT * from test
    WHERE last_name='Widenius' OR first_name='Michael';


Ïà¹ØÎĵµ£º

mysql¼¶ÁªÉ¾³ý Mysql µÄ Cascade Restrict

½ñÌìÓöµ½Êý¾Ý¿âµÄÒ»¸öÎÊÌ⣬¾ÍÊÇÿµ±´ÓÖ÷±íÖÐɾ³ýÒ»¸öÖ÷¼üidʱ£¬ÓÉÓÚÓëËûÏà¹ØÁªµÄ±íÖÐÓÐÏà¹ØµÄ×Ö¶ÎÊý¾Ý£¬ËùÒÔÎÞ·¨É¾³ý¡£²éÁËÒ»´ó¶Ñ×ÊÁÏ£¬·¢ÏÖÎÒ½¨±í¹ØÁªÓõÄÊÇon Restrict.¿ÉÄÜÎÊÌâ¾Í³öÔÚÕâÀï°É¡£ 
Íâ¼üÔ¼Êø¶Ô×Ó±íµÄº¬Òå: 
  Èç¹ûÔÚ¸¸±íÖÐÕÒ²»µ½ºòÑ¡¼ü,Ôò²»ÔÊÐíÔÚ×Ó±íÉϽøÐÐinsert/update 
Íâ¼üÔ¼Êø ......

MYSQL Çó¸ßÊÖ°ïÖú

¸÷λ¸ßÊֺá£Ð¡µÜѧϰJAVA²»¾Ã£¬È»ºóÔÙÓÃMYSQLÊý¾Ý¿â¡£
ÓÉÓÚÊÇÓñðÈ˵ĵķ¶Àýѧϰ£¬ËùÒÔ³öÏÖºÜ¶àÆæ¹ÖµÄÎÊÌâ
ÎÒÓÃ×Ô¼ºµÄMYSQL ·þÎñÆ÷£¬È»ºó°Ñ±ðÈ˵ÄÊý¾Ý¿âµ¼½øÀ´¡£È»ºó³öÏÖ°æ±¾ÎÊÌâ¡£
ÎÊÌâÈçÏÂ
Table './db_librarysys/tb_manager' was created with a different version of MySQL and cannot be read
2010-4-28 22:44 ......

MYSQLÍü¼ÇÃÜÂë½â¾ö·½·¨ »ÆÃöÓñ

Windows: 
1. ÓÃϵͳ¹ÜÀíÔ±µÇ½ϵͳ¡£ 
2. Í£Ö¹MySQLµÄ·þÎñ¡£ 
3. ½øÈëÃüÁî´°¿Ú(cmd)£¬È»ºó½øÈëMySQLµÄ°²×°Ä¿Â¼£¬±ÈÈçÎҵݲװĿ¼ÊÇc:\mysql,½øÈëC:\mysql\bin 
4. Ìø¹ýȨÏÞ¼ì²éÆô¶¯MySQL£¬ 
c:\mysql\bin>mysqld-nt --skip-grant-tables
5. ÖØÐ´ò¿ªÒ»¸öcmd´°¿Ú£¬½øÈëc:\mysql\b ......

MySQL .frm .myd .myi Îļþ ¼°Êý¾Ý¿â±¾µØÒÆÖ²

     ½ñÌìÔÚʵ¼Ê¿ª·¢ÖжÔÓÚMySQLÊý¾Ý¿â½øÐÐÒÆÖ²·¢ÉúµÄÎÊÌâÀ´ËµÏÂ. ¿ªÊ¼°Ñ±¾µØdataÖеÄÊý¾Ý¿âÎļþ¿½±´µ½Áíһ̨»ú×ÓÉÏTest, Ö´ÐÐshow tables ; ¿ÉÒÔ¿´µ½Êý¾Ý¿â±í,µ«ÊÇ¶Ô±í½øÐÐÈκβÙ×÷¶¼±¨´í: ±í²»´æÔÚ , Ô­ÒÔΪMysqlµÄÊý¾Ý¿âÎļþ(.frm)Copy->stickµ½±¾µØ°²×°MySQLDBĿ¼µÄdataÎļþ¼ÐϾͿÉÒÔ.ÊÂʵ²»Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ