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?