来自后台工作者的文本框文本?(Textbox text from background worker?)
我一直在试图弄清楚如何从后台工作者中获取文本框的文本或其他属性。 有人知道怎么做这个吗? 我不能将它作为参数传递,因为它需要实时。 谢谢您的帮助!
I've been trying to figure out how to get my textbox's text or other property from within a background worker. Does anybody know how to do this? I cannot pass it as a param because it needs to be real-time. Thanks for the help!
原文:https://stackoverflow.com/questions/6585017
更新时间:2022-04-12 08:04
最满意答案
你根本不需要IF。 只需在触发器上执行
insert select
,如下所示:INSERT INTO table_b (user_id, domi, ipiresia) SELECT NEW.user_id, NEW.domi, NEW.ipiresia FROM table_a WHERE NOT EXISTS (select 1 from table_b where user_id = NEW.user_id);
You don't need an IF at all. Just do an
insert select
on your trigger like this:INSERT INTO table_b (user_id, domi, ipiresia) SELECT NEW.user_id, NEW.domi, NEW.ipiresia FROM table_a WHERE NOT EXISTS (select 1 from table_b where user_id = NEW.user_id);
相关问答
更多-
有什么数据库专业书籍介绍?[2022-05-19]
mysql -
试试这个,但为什么你会想到使用触发器呢? DELIMITER $$ CREATE TRIGGER trigger_name AFTER INSERT ON tableA FOR EACH ROW BEGIN INSERT INTO tableB SET sku_copy = OLD.sku, order_id = OLD.order_id, order = OLD.order; ...
-
感谢Radosław的帮助,这是我解决我的问题的方法,如果它对某人有用: BEGIN IF (NEW.updator_trigger = 'ee') THEN CALL sp_tbl_activity_log_insert (NEW.id_component, NEW.value); END IF; END 祝你有美好的一天。 Thanks to the help of Radosław, this is how I solved my problem, if it might be useful ...
-
当条件为真时,如何使用MySQL触发器更新多个表?(How do I use a MySQL trigger to update multiple tables when a condition is true?)[2022-11-26]
你可以做这样的事情 DELIMITER $$ CREATE TRIGGER visitor_validation BEFORE INSERT ON ratingsvisitors FOR EACH ROW BEGIN Set @counts=(SELECT count(*) from ratingsvisitors where visotrid=new.userid AND profileid=New.profileid AND itemid=New.itemid AND likevalidati ... -
如果条件未按预期工作,MySQL AFTER DELETE触发器(MySQL AFTER DELETE trigger if condition is not working as expected)[2022-01-26]
我不同意,这是为什么。 drop trigger if exists Tafter_aff_purchases; delimiter // CREATE DEFINER=`root`@`localhost` TRIGGER `Tafter_aff_purchases` AFTER delete ON `aff_purchases` FOR EACH ROW BEGIN #insert into errors (msg) values (concat('old.id = ',old.id) ... -
正确的语法看起来像这样: DELIMITER $$ CREATE TRIGGER deletePerformer BEFORE DELETE ON Performers FOR EACH ROW BEGIN If (NOT EXISTS (SELECT 1 FROM Performers p2 WHERE p2.ActivityID = old.ActivityId AND ...
-
GROUP是MySQL中的保留字( 由GROUP BY-Function使用 )。 所以你的Trigger-Function应该是: CREATE TRIGGER register_client_group AFTER INSERT ON customer FOR EACH ROW BEGIN IF (NEW.`group`='Business' AND NEW.subscribed=true) THEN INSERT INTO groups_customer (id_g ...
-
否则,如果应该是elseif(没有空格)如果OLD.type = profile看起来不正确,应该用单引号进行字符串比较。 Else if should be elseif (no space) IF OLD.type = profile doesn't look right should be in single quotes for a string comparison.
-
MySQL触发器IF条件(MySQL Trigger IF Condition)[2022-03-27]
delimiter | CREATE TRIGGER inserttrigger AFTER INSERT ON table1 FOR EACH ROW BEGIN INSERT INTO table2 SET col1 = NEW.col1, col2 = NEW.col2, col3 = case when LENGTH(NEW.col3) > 20 then NEW.col3 end; ... -
MySQL触发器的IF条件(IF condition on MySQL trigger)[2023-05-31]
你根本不需要IF。 只需在触发器上执行insert select ,如下所示: INSERT INTO table_b (user_id, domi, ipiresia) SELECT NEW.user_id, NEW.domi, NEW.ipiresia FROM table_a WHERE NOT EXISTS (select 1 from table_b where user_id = NEW.user_id); You don't need an IF at all. Ju ...