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

mysqlµÄÐ¶ÔØÎÊÌ⣡

   ×î½üÔÚѧϰtomcat+mysql¿ª·¢web£¬ÔÚ°²×°ºÍÐ¶ÔØmysqlµÄ¹ý³ÌÖÐÓöµ½ÁËһЩÎÊÌ⣬ÕÛÌÚÁËÎҺü¸Ìì¡£ÔÚÕâÀï¸ø´ó¼Ò½ÌÒ»ÏÂÍêÕûµÄÐ¶ÔØmysqlµÄ¹ý³Ì¡£
    ÓÐʱºò֮ǰ°²×°¹ýmysqlÐ¶ÔØºóÓÖÖØÐ°²×°µÄ¹ý³ÌÖУ¬°²×°ºÃµÄmysql½ø²»È¥£¬ÈÃÈ˾õµÃºÜÐÄ·³£¬×Ô¼ºÒѾ­Ð¶ÔØÁË£¬ÖØÐÂ×°Á˺óΪʲô½ø²»È¥ÄØ¡·£¿£¿ Ô­ÒòÊÇÐ¶ÔØ¹ý³Ì²¢²»ÍêÕû¡£ÎҰѹý³ÌÖзÖΪÒÔϼ¸¸ö¹ý³Ì¡£
  1£ºµ½¿ØÖÆÃæ°å———Ìí¼Ó»òɾ³ý³ÌÐòÀïÕÒµ½mysqlÑ¡ÔñÐ¶ÔØ£»
  2£º°ÑÕâ¸öÎļþҲɾ³ýÁËX:\Program Files\MySQL£¬¾ÍÊǰÑÕâ¸öĿ¼Ҳɾ³ýÁË£»
  3£ºÏÂÃæÒ²¾ÍÊÇ×îÖØÒªµÄÒ»µã£¬Ò²ÊÇÈúܶàÈËÀ§»óµÄÒ»µã¡£ÆäʵmysqlµÄ°²×°¹ý³ÌÖÐÒѾ­ÔÚÕâ¸öĿ¼ĬÈÏÁËÒ»¸ömysqlÎļþ£»
      ÔÚX:\Documents and Settings\All Users\Application DataÔÚÕâ¸öĿ¼Ï»¹ÓÐÒ»¸ömysqlÎļþ£¬°ÑÕâҲɾ³ýÁË£¬Õâ¾ÍÍêÃÀÐ¶ÔØÁË¡£
      ½ÓÏÂÀ´Äã¾ÍÄÜÖØÐ°²×°ÄãµÄmysqlÁË£¬È»ºó½øÐÐÅäÖá£
   ºÙºÙ£¬×£ÄãÃdzɹ¦¡£  ÎÒÊǸö´ó²ËÄñ£¬Ï£ÍûÄܰïÖúµ½Ò»Ð©ºÍÎÒÒ»ÑùµÄ²ËÄñ£¬ÉÙ×ßÍä·£¬ÎÒ×ßÁË£¬Äã¾Í²»ÒªÁË£¡£¡


Ïà¹ØÎĵµ£º

MySQL´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

MySQL²»Ö§³ÖINTERSECTºÍMINUS£¬¼°ÆäÌæ´ú·½·¨

Doing INTERSECT and MINUS in MySQL
By Carsten | October 3, 2005
Doing an INTERSECT
An INTERSECT is simply an inner join where we compare the tuples of one table with those of the other, and select those that appear in both while weeding out duplicates. So
SELECT member_id, name from a
INTERSECT ......

MySQL´î½¨


Ò»¡¢MySQL°²×°£º
Ìí¼ÓϵͳÓû§£º
groupadd mysql (/usr/sbin/groupadd)
useradd -g mysql mysql
°²×°²½Ö裺
tar zxfv mysql-*.tar.gz(mysql-5.0.51a)
./configure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
bin/mysql_install_db --user ......

OracleºÍMySQLÊý¾Ý¿âµÄһЩ¼òµ¥ÃüÁî¶Ô±È

ÒÔÏÂΪOracleºÍMySQLÊý¾Ý¿âµÄһЩ¼òµ¥ÃüÁî¶Ô±È£¬¿´¿´ËüÃÇÖ®¼ä´æÔÚÄÄЩ²îÒì
¡¡¡¡SQL> select to_char(sysdate,'yyyy-mm-dd') from dual;
¡¡¡¡SQL> select to_char(sysdate,'hh24-mi-ss') from dual;
¡¡¡¡mysql> select date_format(now(),'%Y-%m-%d');
¡¡¡¡mysql> select time_format(now(),'%H-%i-%S');
¡¡¡¡ÈÕÆÚº ......

¹ØÓÚMySQLµÄJDBCÇý¶¯µÄÎÊÌâ

°²×°JDBCÇý¶¯£º
½âѹËõmysql-connector-java-3.1.10.zip
½«ÒªÊ¹ÓõÄÊÇmysql-connector-java-3.1.10-bin-g.jarºÍmysql-connector-java-3.1.10-bin.jar
ÅäÖÃ
ÔÚC:\Program Files\JavaĿ¼Ï½¨Á¢mysqlforjdbc×ÓĿ¼£¬½øÈë¸ÃĿ¼½«mysql-connector-java-3.1.10-bin.jarµ½¸ÃĿ¼ÏÂ
½øÈëC:\Program Files\Java\jdk1.5.0_04\l ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ