Mysql·Ö²¼ÊÂÎñµÄ̽Ë÷
ÓÉÓÚÏîÄ¿ÐèÒª,¶Ômysql·Ö²¼ÊÂÎñÓÐÒ»¶¨ÒªÇó.ÕâÀïÏȼòµ¥ËµÃ÷±ØÒª.
¼ÙÉè,ÈÕ³£²ÆÎñÖÐ,ÒªÍê³ÉÒ»¸öÓµ»¤¶©¹º,±ØÐ뽫¶¨µ¥²Ù×÷ºÍ²ÆÎñ²Ù×÷·âÔÚÒ»¸öÊÂÎñÖвÅÄܱ£Ö¤½»Ò×ÍêÕûÐÔ.
Èç¹û¶¨µ¥ºÍ²ÆÎñÊý¾Ý¶¼·Ö²¼ÔÚ¸÷×ÔµÄʵÀýÖÐ,Ôò±ØÐëÓ÷ֲ¼ÊÂÎñ²ÅÄÜÂú×ã.
·Ï»°²»¶à£¬½øÈë·Ö²¼ÊÂÎñ̽Ë÷¡£
(±¾ÎÄÀý×ÓÀ´×ÔÍøÂ磬±¾ÎÄÖ»×¢ÖØÌ½Ë÷£©
1.ÔÚ±¾»ú localhostºÍÁíһ̨»úÆ÷ÉÏ192.168.123.xxxÉÏÖ§³Ö·Ö²¼ÊÂÎñµÄÊý¾Ý¿âtestÀィϱí:
CREATE TABLE `test_transation1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
2.È»ºóÿ¸ö±í·Ö±ð²åÈëÊý¾Ý
insert into test_transation1 (name) value('jonhn2');
insert into test_transation1 (name) value('jonhn');
3.ÓÃϽű¾²âÊÔ
<?php
$mapfarm = new mysqli("192.168.123.xx","test","testtest","test");
$map = new mysqli("localhost","root","","test");
$age = rand(1, 255);
$grid = uniqid("");
$map->query("XA START '$grid'");
$mapfarm->query("XA START '$grid'");
$values = array(1,"");
$id = rand(1,2);
try {
$sql="UPDATE test_transation1 SET name=$age WHERE id=$id";
print $sql." 113 <br>";
$return = $map->query($sql);
if($return == false) {
throw new Exception("<a href='http://'>113¸üÐÂʧ°Ü!$sql </a>");
}
$sql="UPDATE test_transation1 SET name=$age WHERE id=$id";
print $sql." 116 <br>";
$return = $mapfarm->query($sql);
if($return == false) {
throw new Exception("116¸üÐÂʧ°Ü! ");
}
$map->query("XA END '$grid'");
$map->query("XA PREPARE '$grid'");
$mapfarm->query("XA END '$grid'");
$mapfarm->query("XA PREPARE '$grid'");
$mapfarm->query("XA COMMIT '$grid'");
$map->query("XA COMMIT '$grid'");
} catch (Exception $e) {
$mapfarm->query("XA ROLLBACK '$grid'");
$map->query("XA ROLLBACK '$grid'");
print "roll
Ïà¹ØÎĵµ£º
mysql½¨Á¢Ò»¸ö±í¸ñ£º
create table hyhtbsc(
id int(4) primary key auto_increment,
username varchar(20),
password varchar(20)
);
²éѯÊý¾Ý¿âÄÚÈÝ£º
<?php
$conn = mysql_connect("localhost","root","pass");
mysql_select_db("mydb",$conn);
$sql = "select * from mytable";
$result = mysql_query($ ......
MySQL´´½¨¹ØÁª±í¿ÉÒÔÀí½âΪÊÇÁ½¸ö±íÖ®¼äÓиöÍâ¼ü¹ØÏµ£¬µ«ÕâÁ½¸ö±í±ØÐëÂú×ãÈý¸öÌõ¼þ
1.Á½¸ö±í±ØÐëÊÇInnoDBÊý¾ÝÒý ......
±¾ÎÄ×ªÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......
Mysql°²×°
MysqlµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¬½¨ÒéÑ¡Ôñ4.0.20d°æ±¾¡£ÕâÀï²»Ïêϸ˵Ã÷¡£
¡¡¡¡ÏÂÔØ»ñµÃMysqlµÄfor win32°²×°°üºó£¬ÓÃwinzip½âѹËõ£¬Ö±½ÓÔËÐÐsetup.exe£¬ÐèҪעÒâµÄÊÇÑ¡ÔñÒ»¸ö°²×°Â·¾¶£¬µ±È»£¬°²×°Â·¾¶¿ÉÒÔÈÎÒ⣬½¨ÒéÑ¡ÔñC:\MySQLĿ¼¡£°²×°Íê³ÉºóMySQLÒ²¾ÍÍê³É ......
ÏÂÃæµÄÊÇMySQL°²×°µÄͼ½â:¡¡¡¡
Ë«»÷ÔËÐГsetup.exe”£¬³öÏÖÈçϽçÃæ£º
mysql°²×°Ïòµ¼Æô¶¯£¬°´“Next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ· ......