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
Ïà¹ØÎÊ´ð£º
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
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°æ±¾µÄ£¡
Èç¹ûʵÔÚ²»ÐÐÄÇô¸ÃÓøöʲôÓï¾ä´úÌæÐ§Âʸü¸ßÄØ ......
Java code:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was51093 seconds ago.The last packet sent successfully to the server was 5 ......