mysql´´½¨´¥·¢Æ÷±¨´í

ÕâÊÇÎҵĵÚÒ»Õűí:ÒÔϳÆA
create table clientLog
(id int primary key auto_increment,cimusername varchar(20),
username varchar(50),
password varchar(50),defrayPassWord varchar(50),
tel varchar(30),createtime timestamp default CURRENT_TIMESTAMP,
updatecreatetime varchar(30),buyongyuanyin varchar(300));


ÕâÊÇÎҵĵÚÒ»Õűí:ÒÔϳÆB
create table clientLogTig(id int primary key auto_increment,tig_clientLog_id int, tig_cimusername varchar(50),
tig_username varchar(50),tig_password varchar(50),tig_defrayPassWord varchar(50),
tig_buyongyuanyin varchar(50),tig_tel varchar(50) ,tig_createtime timestamp default CURRENT_TIMESTAMP);


Êý¾Ý¿âmysql.ÎÒÏëÔÚ±íA×öÐ޸IJÙ×÷µÄʱºò°ÑÔ­À´µÄÊý¾Ý±£´æÔÚB±íÖÐ.ÎÒ´´½¨´¥·¢Æ÷ÈçÏÂ:
create trigger tigBisu
after
update on clientLog for each row
begin
insert into clientLogTig values(null,old.id,old.cimusername,old.username,old.password,old.defrayPassWord,old,buyongyuanyin,old.tel)
end;


µ«»á³ö´í,Íû¸ßÊÖÃÇÖ¸½ÌÏÂ.×¢:Êý¾Ý¿âÀïûÓÐÈκδ¥·¢Æ÷.
³ö´íÈçÏÂ:
you have an error in your SQL syntax;check the manual that corresphonds to your mysql server varsion for the right syntax to use near 'insert into clientLogTig values(null,old.id,old.cimusername,old.username,old.pas'line 5

ÔÚÏßµÈ.

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (free