ÔÚWebLogic 9ÖÐÅäÖÃMySqlµÄÊý¾ÝÔ´
µÚÒ»²½£¬ÏÂÔØMysqlµÄJDBCÇý¶¯³ÌÐò£¬ÃûΪconnectorJ¡£ÏÂÔØÍøÖ·£ºhttp://dev.mysql.com/downloads/connector/j/
½âѹËõzipÎļþºó£¬½«Îļþmysql-connector-java-5.1.12-bin.jarµ½Ä¿Â¼d:\Software\MySQL\MySQL Server 5.1\jdbcdriver\ÖÐ
µÚ¶þ²½£¬ÐÞ¸ÄÎļþd:\Software\bea\WebLogic 9.23\user_projects\domains\MyDomain\bin\startWebLogic.cmd
set CLASSPATH=%CLASSPATH%;%MEDREC_WEBLOGIC_CLASSPATH%;D:\Software\MySQL\MySQL Server 5.1\jdbcdriver\mysql-connector-java-5.1.12-bin.jar
µÚÈý²½£¬ÔÚWebLogicµÄ¹ÜÀí½çÃæÖÐÅäÖÃJDBCÊý¾ÝÔ´¡£
ÀûÓÃ×óÃæÀ¸Î»ÖеÄServices>>JDBC>>Data Source¡£
ÐèÒª¸øÊý¾ÝÔ´ºÍJNDIÃüÃû¡£ÐèÒªÊäÈëÊý¾Ý¿âÃû¡¢µÇ¼Ãû¡¢ÃÜÂëºÍÊý¾Ý±íÃû×Ö¡£
Ïà¹ØÎĵµ£º
http://hi.baidu.com/emersonm/blog/item/ee230a36ca566fd7a2cc2b4a.html
linuxϽâ¾ömysqlµÄ×Ö·û±àÂëÎÊÌâ
2009-10-06 21:03
mysqlµÄ×Ö·û±àÂëÊDZȷ±ËöµÄÊÂÇ飬ÎÒÓõÄfedora11ĬÈÏ°²×°mysql5.1
$mysql --user=root --password=²¼À²¼À²¼À
½øÈëºó
mysql>show variables like 'character%';   ......
²éѯÖظ´¼Ç¼ select * from table GROUP BY name
Ö»°ÑÓÐÖظ´µÄÏÔʾ³öÀ´
select * ,count(*) as nums from tab_a group by name having nums>1
·½·¨Ò»£º£¨Õâ¸ö·½·¨±È½Ï²»´í£¬Ö»ÊÇ×ÔÔö×ֶλáÖؽ¨£©
н¨Ò»¸öÁÙʱ±í
create table tmp as select * &nb ......
1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º use mydb
2. ʼþ
²é¿´Ê¼þ£º show events
Æô¶¯µ÷¶ÈÆ÷: set global event_scheduer = 1;
²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......
Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷ÉÏ°²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......