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

mysqlÍøÕ¾ÇÄÈ»¸Ä°æ£¬sun½«³ÉΪһ´úÈ˵ļÇÒä¡£

½ñÌìµ½mysqlÍøÕ¾¿´¿´·¢ÏÖûÓÐÁËsun LOGO£¬Ò²ÕÒ²»µ½mysql downloadsÏÂÔØÁ´½Ó
ÒªÊÖ¹¤´òÈëhttp://dev.mysql.com²ÅÐУ¬²»½ûÉÁ¹ýһ˿Á¹Ò⣬ÒÔǰ¼á³ÖʹÓÃmysqlÏÖÔÚ»¹Òª¼á³ÖÂð£¬
ÒÔǰÐÄÀïÒ»Ö±ÔÚÏëÒ»Ö±»áʹÓÃmysqlµÄ£¬µ«ÊÇÏÖÔڸоõµ½ºÜʧÍû£¬´ìÕÛ£¬½¹ÂÇ£¬²»ÖªÒÔºó»áÔõôÑù
×Ô¼º¼¸ÄêÀ´Ò»Ö±Ê¹ÓÃLAMP×éºÏ£¬ÖªÊ¶¶¼ÊÇÊÇÎ§ÈÆ×ÅÕâ¸ö×éºÏÕ¹¿ª£¬PostgresSQLÒ»Ö±Ìý˵£¬×Ô¼º´ÓÀ´Ã»ÓÐʹÓùý
¸Ð¾õİÉú£¬ÏÖÔÚûÓÐÒ»µã°²È«¸Ð¡£
mysqlËãµÃÉÏÊÇÒ»¸öΰ´óµÄ²úÆ·£¬ÏëÏëºÃ¼¸ÄêǰÔÚÊéµêÎÞÒâ¿´µ½Ò»±¾½éÉÜmysqlµÄÊ飬¸Ð¾õmysql¶àôÃìС£¬¶àô²Ý¸ù
¸ú΢Èí£¬Oracle£¬IBM DBÈçÀ×¹á¶ú£¬¹â»ÔÐÎÏó£¬×Ô¼º¸ù±¾²»Ï÷¿´Ò»ÑÛ£¬ºóÀ´£¬ËµÊµ»°ÎªÁËÉú»î£¬ÎªÁ˳Է¹Ö»ºÃ×öweb¿ª·¢£¬Ê¹ÓÃÁË
phpºÍmysql£¬¾­¹ýǰ±²Ö¸µ¼ºÜ¿ì¾ÍÈëÃÅÁË£¬¼ÓµÄphpmyadmin¹¤¾ßʹÓÃmysqlÔ½À´Ô½Ë³ÊÖ¡£ÏÖÔÚÕæ²»¸ÒÐ¡ÇÆmysql¡£
ĿǰmysqlÒ²ÓжàÖÖ¼¯Èº½â¾ö·½°¸£¬ºÜ¶àÍøÂ繫˾¶¼ÊÇʹÓÃmysqlÁË¡£
mysqlµÄδÀ´£¬¿ÉÄÜ
Oracle¼ÌÐø°´ÕÕÏòÅ·Ã˱£Ö¤¿ªÔ´¼¸Ä꣬¼¸Äêºó¾Í¹ØÁË»òÕß°ÑmysqlÁ¹ÔÚÒ»±ß¡£Õâ¸öĿǰһ°ãÕý³£²Â²â¡£
Ò²ÓпÉÄÜmysql·Ö³öÀ´µÍ°æ±¾¼ÌÐøÃâ·Ñ£¬Ñ§redhatÒ»Ñù¡£»¹ÓÐÒ»ÖÖ¿ÉÄÜÊÇmysql°ëËÀ²»»î£¬¾ÍÊÇÓÐһЩºÜÐèÒªµÄ¹¦ÄÜÒªÊÕ·Ñ¡£
Ãâ·Ñʲô¶¼±ðÏë¡£
µ«Ô¸mysql»¹Äܱ£ÁôĿǰ״¿ö¡£


Ïà¹ØÎĵµ£º

MYSQL´ÓÎı¾ÎļþÖ´ÐÐSQL


½«SQLÓï¾ä·Åµ½Ò»¸öÎļþÖÐÈ»ºó¸æËßmysql´Ó¸ÃÎļþ¶ÁÈ¡ÊäÈ룬eg£º
shell>mysql db_name < text_file
Èç¹ûÕýÔÚÔËÐÐmysql£¬¿ÉÒÔʹÓÃ"source"»ò"\."ÃüÁîÖ´ÐÐSQL½Å±¾Îļþ£º
mysql>source filename
mysql>\. filename
ÀýÈ磬ҪÔÚÊý¾Ý¿âtestÖд´½¨±íºÍ²åÈëÊý¾Ý£¬ÆäÖд´½¨±íºÍ²åÈëÊý¾ÝµÄSQLÓï ......

Mysql³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

MySQLÊý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹

ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Maste ......

mysql Óï·¨

Transact_SQLСÊÖ²á
*******************Transact_SQL********************
--Óï ¾ä                                ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT & ......

mysqlÖÐGROUP BY½áºÏGROUP_CONCATµÄʹÓà [ת]

http://javeye.javaeye.com/blog/558093
ÎÒÃÇÖªµÀ£¬group by¿ÉÒÔ½«sql²éѯ½á¹û°´ÕÕgroup byºóÃæÁнøÐзÖÀàÏÔʾ¡£±ÈÈ磺
Sql´úÂë
select
 columnA,columnB 
from
 
table
 
group
 
by
 columnA,columnB  
select columnA,columnB from table group by columnA,colum ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ