Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ³£ÓÃÃüÁî £¨×ª£©

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

Linux»·¾³µÄAMP°²×° MYSQL°²×°


1¡¢MYSQLµÄ°²×°
1£©Ê×Ïȵ±È»ÊÇÏÂÔØÔ´Âë°ü¿©£¬È磺mysql-5.0.27µÄ°²×°£¬http://www.mysql.com
2£©½âѹËõ£¬>tar -zxvf mysql-5.0.27.tar.gz
3£©½âѹÍê³É£¬½øÈëmysql-5.0.27Îļþ¼Ð£¬>cd mysql-5.0.27
4£©°²×°ÅäÖã¬>./configure --prefix=/opt/mysql --with-extra-charsets=all --with-unix-socket-path=/opt/m ......

mysql Ë÷Òý»úÖÆ

Chapter 4. Indexes
Ë÷ÒýÓÐÖúÓÚMySQLÔÚºÆÈçÑ̺£µÄÊý¾ÝÖÐѸËÙÕÒµ½ºÍÈ¡µÃÕýÈ·µÄ¼Ç¼¡£
4.1 Indexing Basics
4.1.1 Index Concepts
Ë÷ÒýÊǰ´ÕÕijÖÖ¹æÔòÅÅÐòµÄ¡£Ë÷ÒýÒ²¾ÍÊÇÎþÉüһЩ¿Õ¼äºÍcpuµÄ¿ªÏúÀ´Ê¹ÄãµÄ²éѯÅܵøü¿ìµã¡£ÁíÍâÌáÐѵÄÊÇ£¬¶ÔÓÚMySQLÀ´½²£¬ÊõÓï“Key”ºÍ“Index”ÊÇ¿ÉÒÔ»¥ÏàÌæ»»µÄ¡£
4. ......

mysql¸´ÖÆ(Replication)ģʽ Ö÷´Ó(Master Slave)ģʽ

Ö÷´ÓģʽµÄÌØÐÔ¾ÍÊÇһ̨·þÎñÆ÷×÷ΪÖ÷·þÎñÆ÷£¬ÆäÓà·þÎñÆ÷×÷Ϊ´Ó·þÎñÆ÷£¬Ö÷·þÎñÆ÷½ÓÊÕÔöɾ¸Ä²éµÄ²Ù×÷£¬´Ó·þÎñÆ÷Ö»ÄܽÓÊÕ²éµÄ²Ù×÷¡£
Ö÷·þÎñÆ÷½«Êý¾Ý¸üÐÂÖÁ´Ó·þÎñÆ÷ÊÇÒì²½µÄ£¬Òì²½µÄÓŵãÊÇ¿ÉÒÔÔÚ·þÎñÆ÷¿ÕÏÐÆÚ¼ä½øÐÐͬ²½£¬¶ø²»±ØÕ¼ÓýôȱµÄ×ÊÔ´£¬È±µã¾ÍÊÇ´Ó·þÎñÆ÷µÄÊý¾ÝºÜ¿ÉÄܲ»ÊÇ×îеġ£
Ö»ÄÜÓ¦ÓÃÓÚ¶ÔÊý¾Ýͬ²½ÒªÇ󲻸ߵij¡ºÏ ......

MySQLÊý¾Ýµ¼Èëµ¼³öcsvÎļþÃüÁî

MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º



sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ