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
Ïà¹ØÎÊ´ð£º
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
SELECT * from alarms where id in (select resource_id from res_products where product=22)
Õâ¸öÓï¾äÔÚmysqlÖÐΪʲô²»ÄÜÖ´ÐУ¿ÎÒµÄmysqlÊý¾Ý¿âÊÇ5.0.27°æ±¾µÄ£¡
Èç¹ûʵÔÚ²»ÐÐÄÇô¸ÃÓøöʲôÓï¾ä´úÌæÐ§Âʸü¸ßÄØ ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......