mysql 常用操作

 

\d //

create trigger tg1  before insert on t1  for each row  

begin 

insert into t2 (id) values (old.id);

end //

\d ;

 

create trigger2 tg2 before delete on t1 for each row

begin

delete from t2 where id= old.id;

end

 

 

auto_increment     :

alter table   tablename  set auto_increment=1;

 

mysql的事务处理（只对innodb有用)

set autocommit=0;

delete from t1 where id=2

savepoint p1;

rollback to p1

rollback

commit