05 2010 档案

• mysql roll back
  摘要：START TRANSACTION(或者begin); SAVEPOINT point1; if ???? then ROLLBACK TO SAVEPOINT point1;　#(回滚到SAVEPOINT处) else　　....... end if; COMMIT;(必须,否则会引起Lock wait timeout exceeded; try restarting transaction的错... 阅读全文
  posted @ 2010-05-27 13:10 谁是菜鸟？ 阅读(412) 评论(0) 推荐(1)
• 为没有自动增长列的表添加自动增长列并更新现有数据
  摘要：DROP PROCEDURE IF EXISTS `CreateIndex` $$CREATE PROCEDURE `CreateIndex`()BEGIN SET @rn=0; UPDATE `表名` SET id = (@rn:=@rn+1) ORDER BY '列名' ASC; alter table `表名`add PRIMARY KEY (id); ALTER TABLE `表名` MO... 阅读全文
  posted @ 2010-05-06 13:52 谁是菜鸟？ 阅读(168) 评论(0) 推荐(0)