在mysql中创建触发器 | 在mysql中创建触发器

本文介绍了在mysql中创建触发器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述 29岁程序员，3月因学历无情被辞！如何编写跟随的触发器我在该客户中有一个客户表如果我 上传excel 包含客户名称，员工姓名的文件 ; 我必须在Table Employee Along Table中插入这个 即 Employee_Along_tb w它有两列Customer_id，Employee_Name 但上传的文件包含客户名称我必须从客户名称读取客户ID并插入 Employee_Along_tb 解决方案如果要在MySQL数据库中创建triger，请参阅文档 [ ^ ]。 How can I write trigger for followingI have one customer table in that customer existif I upload excel file that contain customer name, employee nameI have to insert this both in Table Employee Along Table I.eEmployee_Along_tb which have two column Customer_id, Employee_Namebut uploaded file contain Customer Name I have to read customer id from customer name and insert into Employee_Along_tb 解决方案 If you want to create triger in MySQL database, please see the documentation[^]. 这篇关于在mysql中创建触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！上岸，阿里云！