Unanswered: IS there any MySQL Default tables like DUAL in ORACLE.
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?