Jeetendra,
ERROR 1054 (42S22): Unknown column 'CAMPAIGN_ID' in 'OLD'
But this column is exist in DELETED_CONSUMER_ACTION_AUDIT table.
But does it exist in consumer_profile?
PB
-
Jeetendra Ranjan wrote:
Hi,
I am getting error while creating a simple trigger
mysql> CREATE TRIGGER CO
Hi,
I am getting error while creating a simple trigger
mysql> CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFORE DELETE ON
CONSUMER_PROFILE FOR EACH ROW
-> begin
-> INSERT INTO
DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MID
