CREATE trigger ins before insert on downloader.file
for each row
update new set new.idFile=(select max(idFile) from file)+1;如上建立了触发器,数据库叫downloader,表file里面有一项idFile但是插入时总提示没有new这个表
for each row
update new set new.idFile=(select max(idFile) from file)+1;如上建立了触发器,数据库叫downloader,表file里面有一项idFile但是插入时总提示没有new这个表
for each row
set new.idFile=(select max(idFile)+1 from file)
set new.idFile=(select max(idFile) from file)+1;
for each row
set new.idfile=(select max(idfile) from file)+1;