Create Trigger in mysql

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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 23-Dec-14 19:01pm

hareshdgr8

Add a Solution

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

Add a Solution

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

Maciej Los · Answer 1 · 2014-12-23T20:13:00

Solution 1

If you want to create triger in MySQL database, please see the documentation[^].

Posted 23-Dec-14 20:13pm

Maciej Los

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.

Create Trigger in mysql

1 solution

Solution 1

Add your solution here

Preview 0

Create Trigger in mysql

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us