Click here to Skip to main content
15,885,546 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
XML
How can I write trigger for following

I have one customer table in that customer exist

if I <b>upload excel </b>file that contain customer name, employee name

<u>I have to insert this both in Table Employee Along Table</u> I.e

<b>Employee_Along_tb</b> which have two column Customer_id, Employee_Name

but uploaded file contain Customer Name I have to read customer id from customer name and insert into <b>Employee_Along_tb</b>
Posted
Comments
hareshdgr8 24-Dec-14 1:16am    
I need trigger in MySQL when I write in subject MySQL, code project give me error
Maciej Los 24-Dec-14 2:12am    
Upgrade your question and properly set tags.
MySQL or SQL-Server?
hareshdgr8 24-Dec-14 2:13am    
i tried but same problem exists anyways do have any idea of my question.

1 solution

If you want to create triger in MySQL database, please see the documentation[^].
 
Share this answer
 
Comments
hareshdgr8 24-Dec-14 2:24am    
i go throught from that but there is some problem
Maciej Los 24-Dec-14 2:26am    
"Some problem" - is not informative at all.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900