|
IS there any default table mysql server automatically creates and manages these tables like INSERTED, DELETED table in MSSQL, DUAL table in ORACLE.
I have used in mssql a query in trigger for insert operation
declare trg_cursor cursor for select fname from inserted;
In oracle a query in trigger for insert operation
select system.clsyncseq.nextval into synchpointnumber from dual;
like this i need default tables for mysql to fire a same query.
I have written a trigger on table t1 for insert. When inserted a row to t1 my trigger will read the information from INSERTED, DUAL tables in case of MSSQL, ORACLE instead of table t1.
The same thing I need to write for MySQL for INSERT, UPDATE, DELETE operation.
Can you please direct me to achieve this?
|