Thanks for your reply!
The trigger fails to work. There are no error messages.
My attempt is simple:
Whenever I insert a value in table one, immediately the same data should be inserted in table two as well.
I'm new to SQL. I'm still trying to know why it has failed.
Thanks in advance for any help.
It's been more than 12 hours that I've started working with this small program. Yes, I just now got to know my mistake!
There is nothing wrong with the code but the order of statements. The below code generates what I wanted:
Insert statements should come after trigger. Thanks for your replies!