MYSQL֨װ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÔÚ×°UBUNTUϵͳʱ£¬Í¬Ê±Ñ¡ÁËMYSQL°²×°¡£µ«ÊÇ£¬¹«Ë¾ÆäËûÈ˵ÄMYSQL¶¼ÊÇÊÖ¹¤°²×°ÔÚÁíÒ»¸ö·¾¶Ï£¬¶øÇÒÊDZàÒë°²×°¡£ÎªÁ˱£³ÖÒ»Ö£¬ÎÒÏë°ÑÕâ¸öMYSQLɾ³ý£¬È»ºóÖØÐÂÓð²×°¡£
¸Õ²ÅÔÚÍøÉÏÕÒÁËһЩ·½·¨£¬ËµÊÇʹÓÃrpm¡£
ÎÒÊäÈëÁËÃüÁ
rpm -qa
È´µÃµ½ÁË´íÎóÐÅÏ¢£º
error: cannot open Name index using db3 - No such file or directory ( 2 )
Õâ¸öÊÇÔõô»ØÊ£¿
Çë´ó¼Ò¸æËßÎÒÒ»¸öÍêÕûµÄ·½·¨£¬°ÑMYSQL³¹µ×µØÉ¾³ý¡£
лл£¡
лл»Ø¸´£¡
²»¹ý£¬¿ÉÄÜÒªµÈµ½ÏÂÖÜÔÙ½áÌû£¡ÒòΪÏÖÔÚÎÒÈ¥²»Á˹«Ë¾£¬Ã»°ì·¨²Ù×÷¡£
End_rbody_65844250//-->
¸Ã»Ø¸´ÓÚ2010-05-31 10:19:39±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......
ʹÓÃmysqlµÄjdbc driverÁ¬½ÓmysqlÊý¾Ý¿â¡£¾³£³öÏÖÏÂÃæµÄ²éѯ£¬ÇëÎÊÊǸÉɶµÄ£¿
/* mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) */SHOW
VARIABLES WHERE Variable_name ='language' OR Variable_nam ......