PHP mysqlÊÂÎñ´¦Àí »Ø¹ö²Ù×÷
MYSQLÖÐÖ»ÓÐINNODBºÍBDBÀàÐ͵ÄÊý¾Ý±í²ÅÄÜÖ§³ÖÊÂÎñ´¦Àí£¡ÆäËûµÄÀàÐÍÊDz»Ö§³ÖµÄ£¡
$lnk = mysql_connect("localhost", "root", "");
mysql_select_db("test");
mysql_query("BEGIN");
$query = mysql_query("INSERT INTO test VALUES(1, 'yangjun')");
$q1 = mysql_error();
mysql_query("INSERT INTO test VALUES(1, 'yangjun')");
$q2 = mysql_error();
mysql_query("INSERT INTO test VALUES(2, 'Ñî¿¡')");
$q3 = mysql_error();
if (!$q1 && !$q2 && !$q3) {
mysql_query("COMMIT"); //È«²¿³É¹¦£¬Ìá½»Ö´Ðнá¹û
} else {
mysql_query("ROLLBACK"); //ÓÐÈκδíÎó·¢Éú£¬»Ø¹ö²¢È¡ÏûÖ´Ðнá¹û
}
var_dump($q1, $q2, $q3);
Ïà¹ØÎĵµ£º
Ò»¸ömysqlµÄÁªºÏ²éѯÁÐ×Ó£¬ºÜ»ù±¾µÄ£¬²»¹ýºÜʵÓá£
ÏÈ¿´Êý¾Ý±í¡£Êý¾Ý±íclass£º
-------------------------------
id cname
-------------------------------
1 ÄÐ×°
2 ŮƤ¿ã
3 Å®²ÊÃÞ
-------------------------------
class±í´æ·ÅµÄÊDzúÆ·µÄ´óÀàà ......
QT DataBase SQL Explorer
1¡¢°²×°MySQLµ½¹Ù·½ÍøÕ¾ÏÂÔØMySQLÊý¾Ý¿â£¬·Ç°²×°°æ£¬Ö±½ÓÔËÐÐmysqld½ø³Ìǰ̨µÄ
2¡¢Ìí¼Óϵͳ»·¾³±äÁ¿£¬Path+=':\mysql\bin'µÄpath£¬ÔÙÔÚ¿ªÊ¼ÔËÐУ¬CMD->mysql -uroot µÇ¼µ½mySQLÊý¾Ý¿â
Default passwordûÓеģ¬Óеϰ mysql -uroot -pÊäÈëÃÜÂë£»ÍøÂçµÇ¼£ºmysql -h ip ......
PHPChinaѶ£ºPHPºËÐÄ¿ª·¢ÕßAndrei ZmievskiÔÚ×î½ü¾ÙÐеÄ2009 Zend/PHP»áÒéµÄÖ÷Ìâ·¢ÑÔÖÐÌá³ö£º“ÔÚ½ÓÏÂÀ´µÄPHP6ÖØÒªÉý¼¶ÖУ¬½«Í¨¹ýÖ§³ÖUnicodeÀ´°ïÖú¿ª·¢ÕßÃÇд³öÄܹ»²¿Êðµ½¶à¸ö²»Í¬ÓïÑÔÊг¡µÄÓ¦ÓóÌÐò¡£”
¡¡¡¡ÉÌÒµ¿ª·¢ÖÐÈç¹ûÖ»ÊÇ¿ª·¢ÎªÌØÓïÑÔÊг¡µÄÓ¦ÓóÌÐò£¬¾Í»áʧȥÆäËûµØ·½µÄÉÌÒµ»ú»á¡£ÔçÔÚ2006Äê4Ô£ ......
ÖØÐ°²×°£¬³öÏÖ/etc/init.d/mysql: line 115: /etc/mysql/debian-start: ûÓиÃÎļþ»òĿ¼
invoke-rc.d: initscript mysql, action "start" failed.
ʹÓÃÃüÁsudo aptitude purge mysql-server mysql-server-5.0
È»ºóÔÚÖØÐ°²×°....
apt-get install mysql-server-5.0 ......
±à¼my.cnfÎļþ£¬¼ÓÈ룺
log-slow-queries[=file] #ĬÈÏΪdataĿ¼ÏµÄhostname-slow.logÎļþ
long_query_time=10 (seconds) #Âý²éѯµÄthreshold
log-queries-not-using-indexes #¼Ç¼²»Ê¹ÓÃË÷ÒýµÄ²éѯ
mysqldumpslowÃüÁî»ñµÃÈÕÖ¾ÖÐÏÔʾµÄ²éѯժҪÀ´´¦ÀíÂý²éÑ¯È ......