Sfrgttk

Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?

Can I run 125kHz RF circuit on a breadboard?

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Telemetry for feature health

How to get directions in deep space?

What is the meaning of the following sentence?

Can you identify this lizard-like creature I observed in the UK?

Echo with obfuscation

Is there anyway, I can have two passwords for my wi-fi

Why does the Persian emissary display a string of crowned skulls?

Ways of geometrical multiplication

Is there a RAID 0 Equivalent for RAM?

Overlapping circles covering polygon

What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?

Does Doodling or Improvising on the Piano Have Any Benefits?

How to make money from a browser who sees 5 seconds into the future of any web page?

What is the smallest number n> 5 so that 5 ^ n ends with "3125"?

Anime with legendary swords made from talismans and a man who could change them with a shattered body

What does "tick" mean in this sentence?

Deciphering cause of death?

Can I say "fingers" when referring to toes?

How to leave product feedback on macOS?

Limit max CPU usage SQL SERVER with WSRM

ContourPlot — How do I color by contour curvature?

mysql trigger before insert

Any reasons trigger AFTER INSERT would not fire?MySQL BEFORE INSERT trigger with IF conditionsHow to implement a query insert into BEFORE INSERT trigger syntaxCreate Trigger MySql update or insert in another tableTrigger BEFORE INSERT from date to datetimeMySQL trigger before insert replace the data with relational tableMysql trigger to update if date match and insert if no match all BEFORE INSERTHow to access data inside a “before insert trigger” for every statementMySQL - INSERT INTO (multiple values) ON DUPLICATE KEY UPDATE …, with BEFORE DELETE triggertrigger to only execute once after multple rows inserted

0

How can i make this trigger update my table DATA if there is no row to update.
Until i insert data in other table lets called ABC, this table uses a after insert trigger to insert information into DATA table , but the problem here is that it is firstly inserted information into Prod_Has_Ma table (its just how the system works).So this is the trigger that Prod_Has_Ma has but it wont update any information into DATA table how can i fix this problem. Is there a awy to verify if the field of DATA table is null and insert corresponding information to it?

I'll aprecciate any type of help, thanks.

DELIMITER 

//

create trigger ai_P_has_M

before insert on Prod_has_Ma



for each row 



BEGIN



update DATA



set 



Cod_Maquina1=new.Cod_Maquina1,



Nombre_Maquina=

(

SELECT Nombre_Maquina

from Maquina

where Cod_Maquina=new.Cod_Maquina1

),



Seccion=

(SELECT Seccion 

from Maquina 

where Cod_Maquina=new.Cod_Maquina1),



id_empresa = 

(SELECT id_empresa 

from Maquina

where Cod_Maquina=new.Cod_Maquina1

)



where Cod_Produccion = new.Cod_Produccion2;



END; 



//

 DELIMITER ;

mysql trigger mysql-workbench

share

asked 3 mins ago

Cristian GarzonCristian Garzon

11

add a comment | 

0

How can i make this trigger update my table DATA if there is no row to update.
Until i insert data in other table lets called ABC, this table uses a after insert trigger to insert information into DATA table , but the problem here is that it is firstly inserted information into Prod_Has_Ma table (its just how the system works).So this is the trigger that Prod_Has_Ma has but it wont update any information into DATA table how can i fix this problem. Is there a awy to verify if the field of DATA table is null and insert corresponding information to it?

I'll aprecciate any type of help, thanks.

DELIMITER 

//

create trigger ai_P_has_M

before insert on Prod_has_Ma



for each row 



BEGIN



update DATA



set 



Cod_Maquina1=new.Cod_Maquina1,



Nombre_Maquina=

(

SELECT Nombre_Maquina

from Maquina

where Cod_Maquina=new.Cod_Maquina1

),



Seccion=

(SELECT Seccion 

from Maquina 

where Cod_Maquina=new.Cod_Maquina1),



id_empresa = 

(SELECT id_empresa 

from Maquina

where Cod_Maquina=new.Cod_Maquina1

)



where Cod_Produccion = new.Cod_Produccion2;



END; 



//

 DELIMITER ;

mysql trigger mysql-workbench

share

asked 3 mins ago

Cristian GarzonCristian Garzon

11

add a comment | 

How can i make this trigger update my table DATA if there is no row to update.
Until i insert data in other table lets called ABC, this table uses a after insert trigger to insert information into DATA table , but the problem here is that it is firstly inserted information into Prod_Has_Ma table (its just how the system works).So this is the trigger that Prod_Has_Ma has but it wont update any information into DATA table how can i fix this problem. Is there a awy to verify if the field of DATA table is null and insert corresponding information to it?

I'll aprecciate any type of help, thanks.

DELIMITER 

//

create trigger ai_P_has_M

before insert on Prod_has_Ma



for each row 



BEGIN



update DATA



set 



Cod_Maquina1=new.Cod_Maquina1,



Nombre_Maquina=

(

SELECT Nombre_Maquina

from Maquina

where Cod_Maquina=new.Cod_Maquina1

),



Seccion=

(SELECT Seccion 

from Maquina 

where Cod_Maquina=new.Cod_Maquina1),



id_empresa = 

(SELECT id_empresa 

from Maquina

where Cod_Maquina=new.Cod_Maquina1

)



where Cod_Produccion = new.Cod_Produccion2;



END; 



//

 DELIMITER ;

mysql trigger mysql-workbench

share

asked 3 mins ago

Cristian GarzonCristian Garzon

11

DELIMITER 

//

create trigger ai_P_has_M

before insert on Prod_has_Ma



for each row 



BEGIN



update DATA



set 



Cod_Maquina1=new.Cod_Maquina1,



Nombre_Maquina=

(

SELECT Nombre_Maquina

from Maquina

where Cod_Maquina=new.Cod_Maquina1

),



Seccion=

(SELECT Seccion 

from Maquina 

where Cod_Maquina=new.Cod_Maquina1),



id_empresa = 

(SELECT id_empresa 

from Maquina

where Cod_Maquina=new.Cod_Maquina1

)



where Cod_Produccion = new.Cod_Produccion2;



END; 



//

 DELIMITER ;

share

asked 3 mins ago

Cristian GarzonCristian Garzon

11

share

asked 3 mins ago

Cristian GarzonCristian Garzon

11

asked 3 mins ago

Cristian GarzonCristian Garzon

11

asked 3 mins ago

Cristian GarzonCristian Garzon

11