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

ÏêÊöÈçºÎÌá¸ßMySQLÖÐÊý¾Ý×°ÔØЧÂÊ

Õª³­×Ô£ºhttp://database.ctocio.com.cn/153/9232653.shtml
ºÜ¶àʱºò¹ØÐĵÄÊÇÓÅ»¯SELECT ²éѯ£¬ÒòΪËüÃÇÊÇ×î³£ÓõIJéѯ£¬¶øÇÒÈ·¶¨ÔõÑùÓÅ»¯ËüÃDz¢²»×ÜÊÇÖ±½ØÁ˵±¡£Ïà¶ÔÀ´Ëµ£¬½«Êý¾Ý×°ÈëÊý¾Ý¿âÊÇÖ±½ØÁ˵±µÄ¡£È»¶ø£¬Ò²´æÔÚ¿ÉÓÃÀ´¸ÄÉÆÊý¾Ý×°ÔزÙ×÷ЧÂʵIJßÂÔ£¬Æä»ù±¾Ô­ÀíÈçÏ£º
¡¡¡¡³ÉÅú×°Ôؽϵ¥ÐÐ×°Ôظü¿ì£¬ÒòΪÔÚ×°ÔØÿ¸ö¼Ç¼ºó£¬²»ÐèҪˢÐÂË÷Òý¸ßËÙ»º´æ;¿ÉÔÚ³ÉÅú¼Ç¼װÈëºó²ÅˢС£
¡¡¡¡ÔÚ±íÎÞË÷ÒýʱװÔرÈË÷Òýºó×°Ôظü¿ì¡£Èç¹ûÓÐË÷Òý£¬²»½ö±ØÐëÔö¼Ó¼Ç¼µ½Êý¾ÝÎļþ£¬¶øÇÒ»¹ÒªÐÞ¸Äÿ¸öË÷ÒýÒÔ·´Ó³Ôö¼ÓÁ˵ÄмǼ¡£
¡¡¡¡½Ï¶ÌµÄSQL Óï¾ä±È½Ï³¤µÄSQL Óï¾äÒª¿ì£¬ÒòΪËüÃÇÉæ¼°·þÎñÆ÷·½µÄ·ÖÎö½ÏÉÙ£¬¶øÇÒ»¹ÒòΪ½«ËüÃÇͨ¹ýÍøÂç´Ó¿Í»§»ú·¢Ë͵½·þÎñÆ÷¸ü¿ì¡£ÕâЩÒòËØÖÐÓÐһЩËƺõ΢²»×ãµÀ(ÌرðÊÇ×îºóÒ»¸öÒòËØ)£¬µ«Èç¹ûҪװÔØ´óÁ¿µÄÊý¾Ý£¬¼´Ê¹ÊǺÜСµÄÒòËØÒ²»á²úÉúºÜ´óµÄ²»Í¬½á¹û¡£ÎÒÃÇ¿ÉÒÔÀûÓÃÉÏÊöµÄÒ»°ãÔ­ÀíÍƵ¼³ö¼¸¸ö¹ØÓÚÈçºÎ×î¿ìµØ×°ÔØÊý¾ÝµÄʵ¼Ê½áÂÛ£º
¡¡¡¡LOAD DATA(°üÀ¨ÆäËùÓÐÐÎʽ)±ÈINSERT ЧÂʸߣ¬ÒòΪÆä³ÉÅú×°ÔØÐС£Ë÷ÒýˢнÏÉÙ£¬²¢ÇÒ·þÎñÆ÷Ö»Ðè·ÖÎöºÍ½âÊÍÒ»ÌõÓï¾ä¶ø²»ÊǼ¸ÌõÓï¾ä¡£
¡¡¡¡LOAD DATA ±ÈLOAD DATA LOCAL ЧÂʸü¸ß¡£ÀûÓÃLOAD DATA£¬Îļþ±ØÐ붨λÔÚ·þÎñÆ÷ÉÏ£¬¶øÇÒ±ØÐë¾ßÓÐFILE È¨ÏÞ£¬µ«·þÎñÆ÷¿É´Ó´ÅÅÌÖ±½Ó¶ÁÈ¡Îļþ¡£ÀûÓÃLOAD DATA LOCAL£¬¿Í»§»ú¶ÁÈ¡Îļþ²¢½«Æäͨ¹ýÍøÂç·¢Ë͸ø·þÎñÆ÷£¬ÕâÑù×öºÜÂý¡£
¡¡¡¡Èç¹û±ØÐëʹÓÃINSERT£¬Ó¦¸ÃÀûÓÃÔÊÐíÔÚµ¥¸öÓï¾äÖÐÖ¸¶¨¶àÐеÄÐÎʽ£¬ÀýÈ磺
¡¡¡¡¿ÉÔÚÓï¾äÖÐÖ¸¶¨µÄÐÐÔ½¶àÔ½ºÃ¡£ÕâÑù»á¼õÉÙËùÐèµÄÓï¾äÊýÄ¿£¬½µµÍË÷ÒýË¢ÐÂÁ¿¡£Èç¹ûʹÓÃmysqldump Éú³ÉÊý¾Ý¿â±¸·ÝÎļþ£¬Ó¦¸ÃʹÓÃ--extended-insert Ñ¡Ïʹת´¢Îļþ°üº¬¶àÐÐINSERT Óï¾ä¡£»¹¿ÉÒÔʹÓÃ- - o p t(ÓÅ»¯) £¬ËüÆôÓÃ--extended-insert Ñ¡Ïî¡£·´Ö®£¬Ó¦¸Ã±ÜÃâʹÓÃmysqldump µÄ--complete-insert Ñ¡Ïî;´ËÑ¡Ïî»áµ¼ÖÂINSERT Óï¾äΪµ¥ÐУ¬Ö´ÐÐʱ¼ä¸ü³¤£¬±È²»ÓÃ--complete-insert Ñ¡ÏîÉú³ÉµÄÓï¾äÐèÒª¸ü¶àµÄ·ÖÎö¡£
¡¡¡¡Ê¹ÓÃѹËõÁ˵Ŀͻ§»ú/·þÎñÆ÷ЭÒéÒÔ¼õÉÙÍøÂçÊý¾ÝÁ÷Á¿¡£¶ÔÓÚ´ó¶àÊýMySQL¿Í»§»ú£¬¿ÉÒÔÓÃ--compress ÃüÁîÐÐÑ¡ÏîÀ´Ö¸¶¨¡£ËüÒ»°ãÖ»ÓÃÓÚ½ÏÂýµÄÍøÂ磬ÒòΪѹËõÐèÒªÕ¼ÓôóÁ¿µÄ´¦ÀíÆ÷ʱ¼ä¡£
¡¡¡¡ÈÃMySQL²åÈëȱʡֵ;²»ÒªÔÚINSERT Óï¾äÖÐÖ¸¶¨½«ÒÔÈÎÒⷽʽ¸³ÓèȱʡֵµÄÁС£Æ½¾ùÀ´Ëµ£¬ÕâÑù×öÓï¾ä»á¸ü¶Ì£¬ÄܼõÉÙͨ¹ýÍøÂç´«Ë͸ø·þÎñÆ÷µÄ×Ö·ûÊý¡£´ËÍ⣬Óï¾ä°üº¬µÄÖµ½ÏÉÙ£¬·þÎñÆ÷Ëù½øÐеķÖÎöºÍת»»¾Í»á½ÏÉÙ¡£
¡¡¡¡Èç¹û±íÊÇË÷ÒýµÄ£¬Ôò¿ÉÀûÓÃÅúÁ¿²åÈë(


Ïà¹ØÎĵµ£º

MySqlÊý¾Ý¿âÖØÉèÃÜÂë

1. ¹ØµôMysql·þÎñ
2.н¨Ò»¸öÎı¾Îļþ£¬ÄÚÈÝÈçÏ£º
UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE User='root';
FLUSH PRIVILEGES;
×¢Ò⣺һ¶¨Òª·ÖÁ½ÐÐд£¬"NewPassword"ΪÄãµÄÐÂÃÜÂë
3. ±£´æÎļþ£¬²¢°ÑËü·ÅÔÚCÅ̸ùĿ¼Ï£¬ÎļþÃûΪ"mysql-init.txt"£ºC:\mysql-init.txt
 
4. ´ò¿ªcmd´°¿Ú£¬Êä ......

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî

MySQLÖг£ÓõÄÐ޸ıíµÄÃüÁî
¹Ø¼ü×Ö: mysql, Ð޸ıí, ÃüÁî
    ÔÚÊý¾Ý¿â²Ù×÷ÖÐ,¸öÈ˾õµÃʹÓõÃ×î¶àµÄ¾ÍÊDzéѯ,È»ºó¾ÍÊǶԱíµÄÐ޸IJÙ×÷ÁË,ÓÈÆäÊǵ±Êý¾Ý¿âµÄÉè¼Æ¹¤×÷ûÓÐ×öºÃʱ.ÏÂÃæ¾ÍMySQLÖÐһЩ³£ÓõÄÐ޸ıíµÄ²Ù×÷½øÐÐ×ܽá:
    ΪÁË·½±ãºóÃæµÄ˵Ã÷,ÏÈ´´½¨Ò»¸ö±í,´´½¨Óï¾äÈçÏÂ:
Create ......

ÔÚMySQLÖе¼Èëµ¼³öÎļþ

Ç°Ì᣺MySQLÖдæÔÚÒ»¸öÓû§×Ô¼º½¨Á¢µÄÊý¾Ý¿â£¬¼ÙÉèΪmydb£¬mydbÖÐÓÐÒ»ÕÅÓû§×Ô¼º½¨Á¢µÄ±í¸ñ£¬¼ÙÉèÃû³ÆΪmytable
ÎÒµÄÇ°Ì᣺MySQLÖдæÔÚÁ½¸öÊý¾Ý¿â£¬yldbºÍyldb2£¬ÆäÖÐyldbÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í£¬ÃûΪpet
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin ......

mysql ·Ö×é»ã×Ü

 1.´´½¨±í£º
    create table groupTable(dept varchar(6),phone varchar(20),amount int);
 2.²åÈë²âÊÔÊý¾Ý£º
    insert groupTable
    select 'ÓªÒµ²¿',8001,20 union all
    select 'ÓªÒµ²¿',8002,30 union all
    se ......

MySQL Storage Engine

http://www.javaeye.com/topic/211951
Õâ¶Îʱ¼äÔÚ¿´¡¶High Performance MySQL¡·£¬¿´µ½´æ´¢ÒýÇæÕâ¸öµØ·½¸Ðµ½ºÜ¶àϸ½Ú±È½ÏÄ°Éú£¬ËùÒÔ×ܽáС¼ÇһЩ
ΪÁËÊÊÓ¦¸÷ÖÖ²»Í¬µÄÔËÐл·¾³£¬MYSQLÌṩÁ˶àÖÖ²»Í¬µÄ´æ´¢ÒýÇ棨Storage Engine £©,ÔÚÓ¦ÓóÌÐò¿ª·¢Õâ¸ö²ãÃæÉÏ£¬¿ª·¢Õß¿ÉÒÔ¸ù¾Ý²»Í¬µÄÐèÇóÑ¡ÔñÊʺϵÄStorage Engine ·½°¸£¬¸üΪÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ