select count(*) from sysobjects where name='trg_pos_machine_insert' 在MYsql中应该用哪张表 'trg_pos_machine_insert'这是触发器
SELECT * FROM `information_schema`.`TRIGGERS` a WHERE a.`TRIGGER_NAME`='trg_pos_machine_insert' AND a.`TRIGGER_SCHEMA`='数据库名'
我给完整的你帮我改下 if (select count(*) from triggers where name='trg_pos_machine_insert') > 0 drop trigger trg_pos_machine_insert;create trigger trg_pos_machine_after_insert AFTER INSERT on pos_machine for each row being insert into pos_receivedate(posno,itemno) values( @posno,"会员资料"); insert into pos_receivedate(posno,itemno) values( @posno,"商品条码"); insert into pos_receivedate(posno,itemno) values( @posno,"商品资料"); insert into pos_receivedate(posno,itemno) values( @posno,"店促商品"); insert into pos_receivedate(posno,itemno) values( @posno,"店促档期"); insert into pos_receivedate(posno,itemno) values( @posno,"DM商品"); insert into pos_receivedate(posno,itemno) values( @posno,"DM档期"); insert into pos_receivedate(posno,itemno) values( @posno,"员工资料"); end ?
CreateDate timestamp default current_timestamp(),
UpdateDate timestamp
这两个我都要获取当前时间要怎么写?
DMId Varchar(4) not null, /*DM促销期数*/
SupId integer not null, /*供应商代码*/
ProId integer not null, /*商品代码*/
OrigInPrice dec(10,2) not null, /*原进价*/
InPrice dec(10,2) not null, /*促销进价*/
OrigSalePrice dec(10,2) not null, /*原售价*/
SalePrice dec(10,2) not null, /*促销售价*/
OrigMemPrice dec(10,2) null, /*原会员价*/
SpecialPrice dec(10,2) null, /*印花价*/
PrePurQty integer null, /*预订进数*/
PreSaleQty integer null, /*预定销量*/
GiftOne Integer null, /*搭赠比1*/
GiftTwo Integer null, /*搭赠比2*/
LimitTimes Integer null, /*限购次数*/
LimitQty integer null, /*限购数量*/
OperatorId char(10) null, /*操作员*/
CreateDate timestamp default current_timestamp(),
UpdateDate timestamp ,
Re varchar(40) null,
SpecBegindate timestamp null,
SpecEndDate timestamp null, constraint p_pmt_detail_dm primary key(DMId,SupId,ProId)
);
在MYsql中应该用哪张表
'trg_pos_machine_insert'这是触发器
if (select count(*) from triggers where name='trg_pos_machine_insert') > 0
drop trigger trg_pos_machine_insert;create trigger trg_pos_machine_after_insert
AFTER INSERT
on pos_machine
for each row
being insert into pos_receivedate(posno,itemno)
values( @posno,"会员资料"); insert into pos_receivedate(posno,itemno)
values( @posno,"商品条码"); insert into pos_receivedate(posno,itemno)
values( @posno,"商品资料"); insert into pos_receivedate(posno,itemno)
values( @posno,"店促商品"); insert into pos_receivedate(posno,itemno)
values( @posno,"店促档期"); insert into pos_receivedate(posno,itemno)
values( @posno,"DM商品"); insert into pos_receivedate(posno,itemno)
values( @posno,"DM档期"); insert into pos_receivedate(posno,itemno)
values( @posno,"员工资料");
end
?
动态创建TRIGGER
怎么创建?