mysql ÖÐµÄ autocommit ±äÁ¿
mysql> show variables like "autocommit";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
ÉèÖÃÍêÖ®ºó¿´¿´¸ÃÖµ
ÄãÒª¿ªÆôÒ»¸öÊÂÎñ£¬Ö±½Ó·¢ËÍbegin ¡£¡£¡£¡£commit¾Í¿ÉÒÔ£¬ºÎ±ØÒªÈ¥¶¯ÓÃÕâ¸ö²ÎÊý¡£
mysqlµÄºóÃæ°æ±¾Ò»Ö±²»ÌᳫÐÞ¸ÄÕâ¸ö²ÎÊý¡£
postgresqlÉõÖÁÈ¡ÏûÁËÕâ¸ö²ÎÊý£¬ÒòΪËüÈÏΪÊÂÎñ¿ØÖÆÓ¦¸ÃÓɿͻ§¶ËÀ´¾ö¶¨
Ïà¹ØÎĵµ£º
°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕß:
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL, ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚ http://helpmysql.org/cn/petition
µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
&nb ......
ʹÓÃmysqlÖеÄwith rollup¿ÉÒԵõ½Ã¿¸ö·Ö×éµÄ»ã×ܼ¶±ðµÄÊý¾Ý£º
±íÈçÏ£º
CREATE TABLE `test3` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name1` varchar(10) DEFAULT NULL,
`name2` varchar(10) DEFAULT NULL,
`cnt` int(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGI ......
net start mysql //Æô¶¯mysql·þÎñ
net stop mysql //Í£Ö¹mysql·þÎñ
mysqld-nt --remove //ɾ³ýmysqlºǫ́·þÎñ
mysqld-nt --install //°²×°mysqlºǫ́·þÎñ
mysqld-nt¿ÉÒÔ»»³Émysqld-max-nt»òmysqld
mysql -u root ......
ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØÐ°²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬× ......