在mysql中创建触发器 [英] Create Trigger in mysql

问题描述

如何编写跟随
 
的触发器我在该客户中有一个客户表
 
如果我<   b  > 上传excel <   / b  > 包含客户名称，员工姓名的文件
 
 <   u  > ; 我必须在Table Employee Along Table中插入这个<   / u  > 即
 
 <   b  >  Employee_Along_tb <   / b  >  w它有两列Customer_id，Employee_Name 
 
但上传的文件包含客户名称我必须从客户名称读取客户ID并插入<  < span class =code-leadattribute> b  >  Employee_Along_tb <   / b  >  

解决方案

如果要在MySQL数据库中创建triger，请参阅文档 [ ^ ]。

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>

解决方案

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

这篇关于在mysql中创建触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！