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
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
SELECT * from alarms where id in (select resource_id from res_products where product=22)
Õâ¸öÓï¾äÔÚmysqlÖÐΪʲô²»ÄÜÖ´ÐУ¿ÎÒµÄmysqlÊý¾Ý¿âÊÇ5.0.27°æ±¾µÄ£¡
Èç¹ûʵÔÚ²»ÐÐÄÇô¸ÃÓøöʲôÓï¾ä´úÌæÐ§Âʸü¸ßÄØ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......