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»¹Äܱ£ÁôĿǰ״¿ö¡£
Ïà¹ØÎĵµ£º
1¡¢HibernateµÄÓ³ÉäÀàÐÍ hibernate mysqlÓ³ÉäÀàÐÍ
Hibernate Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
´óСºÍȡֵ·¶Î§
integer »òÕß int
int »òÕß java.lang.Integer
INTEGER
4 ×Ö½Ú
long
long Long
BIGINT
8 ×Ö½Ú
short
short Short
SMALLINT
2 ×Ö½Ú
byte
byte Byte
TINYINT
1 ×Ö½Ú
floa ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
Ö÷´ÓģʽµÄÌØÐÔ¾ÍÊÇһ̨·þÎñÆ÷×÷ΪÖ÷·þÎñÆ÷£¬ÆäÓà·þÎñÆ÷×÷Ϊ´Ó·þÎñÆ÷£¬Ö÷·þÎñÆ÷½ÓÊÕÔöɾ¸Ä²éµÄ²Ù×÷£¬´Ó·þÎñÆ÷Ö»ÄܽÓÊÕ²éµÄ²Ù×÷¡£
Ö÷·þÎñÆ÷½«Êý¾Ý¸üÐÂÖÁ´Ó·þÎñÆ÷ÊÇÒì²½µÄ£¬Òì²½µÄÓŵãÊÇ¿ÉÒÔÔÚ·þÎñÆ÷¿ÕÏÐÆÚ¼ä½øÐÐͬ²½£¬¶ø²»±ØÕ¼ÓýôȱµÄ×ÊÔ´£¬È±µã¾ÍÊÇ´Ó·þÎñÆ÷µÄÊý¾ÝºÜ¿ÉÄܲ»ÊÇ×îеġ£
Ö»ÄÜÓ¦ÓÃÓÚ¶ÔÊý¾Ýͬ²½ÒªÇ󲻸ߵij¡ºÏ ......
***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG --Ç󯽾ùÖµ
COUNT --ͳ¼ÆÊýÄ¿
MAX --Çó×î´óÖµ
MIN --Çó×îСֵ
SUM --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--M ......
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
È·È ......