Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»¹Äܱ£ÁôÄ¿Ç°×´¿ö¡£


Ïà¹ØÎĵµ£º

HibernateµÄÓ³ÉäÀàÐÍ hibernate 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·þÎñ°²×°ºÍжÔØÃüÁî

ÆäʵÈç¹ûÄã·þÎñÆ÷ÖØа²×°ÁË,Ò²²»±ØÖØа²×°mysql ¼¸¸öСÃüÁî¾Í¸ã¶¨ÁË
Ê×ÏÈÊÇ°²×°mysql·þÎñ:
mysql-nt –install
net start  mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
жÔصÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑжÔز»ÁËÄØ,ÒòΪËûÒѾ­°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......

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

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

mysql ³£Óú¯Êý

Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL        ......

mysql Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

1.Í£µômysqld
  service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
  service mysqld start --skip-networking --skip-grant-tables
  »òÕß
  /opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
  /opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
  skip-grant-tables:Á¬½ÓʱÌø¹ýÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ