Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How do you create a few conditions in the trigger?

E
emran last edited by
How do you create a few conditions in the trigger?
There's a trigger, how do you ask him a few conditions for each pillar?
Let's say if we're updating.:
url_avator - So UPDATE friends_table SET ava... ♪ ♪ ♪ ♪
url_avator2 - So UPDATE friends_table2 SET ava... ♪ ♪ ♪ ♪
```
BEGIN
SET foreign_key_checks =  0 ;
 UPDATE  friends_table  SET  avatar=NEW.avatar  WHERE  avatar=OLD.avatar;
 UPDATE  friends_table2  SET  avatar2=NEW.avatar2  WHERE  avatar2=OLD.avatar2;
SET foreign_key_checks =  1 ;
END
```
Reply Quote 0
1 Reply Last reply

Raziyah00

BEGIN
SET foreign_key_checks =  0 ;
IF (NEW.url_avator<>OLD.url_avator) THEN
    UPDATE  friends_table  SET  avatar=NEW.avatar  WHERE  avatar=OLD.avatar;
END IF;
IF (NEW.url_avator2<>OLD.url_avator2) THEN
    UPDATE  friends_table2  SET  avatar2=NEW.avatar2  WHERE  avatar2=OLD.avatar2;
END IF;
SET foreign_key_checks =  1 ;
END

2
Posts

0
Views

Suggested Topics

E

Get normalized representation of SET datatype
SQL, Database Testing • mysql select mariadb • • elysha

2

0
Votes

2
Posts

0
Views

E

SELECT DISTINCT `int`, SUBSTRING_INDEX(SUBSTRING_INDEX(`set_2`, ',', `mask`), ',', -1) `set` FROM `test_set`, -- generate masks based on SET values list count (SELECT 1 `mask` UNION SELECT 2 UNION SELECT 3) `mask` WHERE `set_2` & 1; fiddle If server version allows build mask in recursive CTE (dynamic count may be used)
C

Receipt of id for mysql
Software Programming • php mysql • • Cleofas

2

0
Votes

2
Posts

0
Views

C

If you have an InnoDB movement in the table, you can use the transactional mechanism: start the transaction, insert a new record, get LAST_INSERT_ID(), update the recording and make a transactional comedian (all of which can be done in one MySQL address):BEGIN TRANSACTION; INSERT INTO insert_test SET name = 'Имя', desc = 'Описание'; UPDATE insert_test SET new_pref = CONCAT('N', id) WHERE id = LAST_INSERT_ID(); COMMIT;
K

Create a Trigger with JOIN to duplicate the data
Software Programming • mysql wordpress • • Kadir

2

0
Votes

2
Posts

0
Views

A

Let's go for parts. Basically your query would be like this:SELECT wp_postmeta.post_id, wp_posts.post_title FROM wp_postmeta INNER JOIN wp_posts on wp_posts.id = wp_postmeta.post_id The problem is that, the same table "wp_postmeta" contains the data of the same post in different records, it requires that a join with the table itself multiple times, for objter name, email and value, something like this: INNER JOIN wp_postmeta wp_name on wp_postmeta.post_id = wp_name.post_id INNER JOIN wp_postmeta wp_email on wp_postmeta.post_id = wp_email.post_id INNER JOIN wp_postmeta wp_adicional on wp_postmeta.post_id = wp_adicional.post_id Note that as are multiplos joins for different purposes, each has one alias different. In addition, you need to filter by "meta_key" to get the correct values, so we can add the clause WHERE, so: WHERE wp_name.meta_key = '_appointment_guest_name' AND wp_email.meta_key = '_appointment_guest_email' AND wp_adicional.meta_key = '_cf_meta_value' Here I used the different alias to filter what each must return.Finally, in order to avoid duplicate results, we will group by "post_id". The complete query is like this:SELECT wp_postmeta.post_id, wp_name.meta_value as nome, wp_email.meta_value as email, wp_adicional.meta_value as adicional, wp_posts.post_title FROM wp_postmeta INNER JOIN wp_postmeta wp_name on wp_postmeta.post_id = wp_name.post_id INNER JOIN wp_postmeta wp_email on wp_postmeta.post_id = wp_email.post_id INNER JOIN wp_postmeta wp_adicional on wp_postmeta.post_id = wp_adicional.post_id INNER JOIN wp_posts on wp_posts.id = wp_postmeta.post_id WHERE wp_name.meta_key = '_appointment_guest_name' AND wp_email.meta_key = '_appointment_guest_email' AND wp_adicional.meta_key = '_cf_meta_value' GROUP BY wp_postmeta.post_id Can be seen working here: http://sqlfiddle.com/#!9/860125/1 Finally, put this in a view:CREATE VIEW MinhaView AS SELECT wp_postmeta.post_id, wp_name.meta_value as nome, wp_email.meta_value as email, wp_adicional.meta_value as adicional, wp_posts.post_title FROM wp_postmeta INNER JOIN wp_postmeta wp_name on wp_postmeta.post_id = wp_name.post_id INNER JOIN wp_postmeta wp_email on wp_postmeta.post_id = wp_email.post_id INNER JOIN wp_postmeta wp_adicional on wp_postmeta.post_id = wp_adicional.post_id INNER JOIN wp_posts on wp_posts.id = wp_postmeta.post_id WHERE wp_name.meta_key = '_appointment_guest_name' AND wp_email.meta_key = '_appointment_guest_email' AND wp_adicional.meta_key = '_cf_meta_value' GROUP BY wp_postmeta.post_id; And there's one SELECT * FROM MinhaViewCan see working with the view here: http://sqlfiddle.com/#!9/7a1cfe/2
J

Create a list of two others on the Scala condition.
Software Programming • scala • • jonetta

2

0
Votes

2
Posts

0
Views

A

Allow me to propose a simple solution in the code plan:val classRoom1 = List(Person(14, "Jimm"),Person(14, "Jack"), Person(13, "Ricky")) val classRoom2 = List(Person(14, "Jimm"),Person(14, "Jack"), Person(13, "Ricky"), Person(13,"Susan"), Person(16, "Jack")) val classRoom3 = classRoom2.filterNot(p => classRoom1.exists(_.name == p.name)) println(classRoom3) //List(Person(13,Susan)) It's complicated. n*m♪If it doesn't work, you can wrap it up and make it linear. But the code will be more complicated.
J

How do I get a SQL disposal request with a condition that there's a record on another condition?
Software Programming • php mysql sql • • juvenalb

2

0
Votes

2
Posts

0
Views

D

delete from article_tags t1 where tag_id = $old_tag and exists(select 1 from article_tags t2 where t1.art_id=t2.art_id and tag_id = $new_tag)
R

MySQL trigger help with the trigger, I want one table to be updated in another table.
Software Programming • mysql trigger • • rosemadder

2

0
Votes

2
Posts

0
Views

K

DELIMITER | CREATE TRIGGER b AFTER INSERT ON booking FOR EACH ROW BEGIN IF NEW.korpus = 1 THEN UPDATE testt.allRooms_1k SET free_1k=free_1k-1 WHERE allRooms_1k.roomId_1k=NEW.myRoomId; ELSEIF NEW.korpus = 2 THEN UPDATE testt.allRooms_2k SET free_2k=free_2k-1 WHERE allRooms_2k.roomId_2k=NEW.myRoomId; END IF; END; | DELIMITER ;
J

What kinds of protection are needed for a financial website with a balance other than protection against xss, csrf and frode attacks?
Software Programming • javascript php sql security • • jonetta

2

0
Votes

2
Posts

0
Views

R

There's only one kind of defense here. literate computer security, which will be handled by the organization. I think we're all afraid to get to the doctor who's gonna write to the "colegi forum before the surgery, you're gonna have to remove the appendicitis, write up where to cut it?" The doctor should know what to do before he gets admitted to a patient. The same applies to serious computer security. Security built on the answers in the forum is some sort of anecdote.
K

Is it a good practice to have the same name with the bank name column?
Software Programming • php sql databank pdo modeling • • kalena

2

0
Votes

2
Posts

0
Views

K

You can say it is. If it doesn't cause a problem, it's a good practice.But like all "good practice", it is only valid when the person knows what he is doing. When the person does not understand why it is being adopted, he is just repeating what others said to him to do, it will always be a bad practice. Even if it's right, if it's hit by coincidence, it's a terrible practice.The only good practice in fact is to understand what you are doing, study deeply the mechanism you are using and analyze the specific situation to determine whether or not you should adopt a particular procedure in that real situation.The purpose of the database column is to store exactly what is in the page form? So it seems okay. Now, if the column keeps a data that has a relationship with this page field, but this occurs only by chance, if this column can have data from other points of the application, that is, if the relationship is indirect, then this can change figure. Or not, after all there are names that are very common.Some people think they use the prefix txt it is not recommended. It's something unnecessary. This is considered https://pt.wikipedia.org/wiki/Nota%C3%A7%C3%A3o_h%C3%BAngara and disincentived for being something superfluous and eventually harmful when it needs for some reason to exchange the type of the data.It may be that the architecture of the application, to which I do not know, may have some specific need that makes it a bad practice, but I cannot affirm.But note that all this is very conceptual. Technically there is nothing that prevents or causes a problem. And maybe this is the real question.Already UPDATE $tabela can be a terrible practice depending on where this variable comes from. It would be asking to suffer a potentially devastating attack on the database. But this is not the focus of the question.
J

How to create a trigger that fills the data in another table with similar fields
Software Programming • sql server sql trigger • • Jolied

2

0
Votes

2
Posts

0
Views

E

SELECT TOP 1 remembers that triggers work 1 in 1 not in select multiple
Triggers
Software Programming • ruby • • Marcee

2

0
Votes

2
Posts

0
Views

G

if (condition1)..(condition2) # do something end The idea is that if the first condition is true, then the invisible lever is switched and the condition will be fulfilled until the second condition is true. Example:(1..20).each do |i| puts i if (i == 3)..(i == 15) end It prints all the numbers from 3 to 15, but if 15 passes in the cycle, it will continue to print.
S

Create trigger for sequence in primary key
Software Programming • oracle • • simrah

2

0
Votes

2
Posts

0
Views

O

What's your Oracle version? If it is 12c, there is now identiy column, which makes the increment by you, without triggers, or sequences:CREATE TABLE identity_test_tab ( id NUMBER GENERATED ALWAYS AS IDENTITY, description VARCHAR2(30) ); If you don't have 12c, I don't see what the trigger is wrong. Does it make a mistake?By the way, try this code:CREATE OR REPLACE TRIGGER dept_bir BEFORE INSERT ON hospede FOR EACH ROW BEGIN :new.id := dept_seq.NEXTVAL; END;
J

How to create a function that creates data for csv
Software Programming • python python 3.x • • juvenalb

2

0
Votes

2
Posts

0
Views

F

m = random.randint(3, 10) n = random.randint(3, 10) new_list = [[random.randint(0, 1) for _ in range(m)] for _ in range(n)] In your code for a list element, a new (emergency) size of the list is calculated, so the table is not available.Calculate the dimensions in advance and don't bother.
C

How do you choose the lines on the condition just so that those do not fit the condition?
Software Programming • sql • • Cleofas

2

0
Votes

2
Posts

0
Views

R

use IHF; select CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN KDK.FIO_OTV END FACT_KOL_DAYS , CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN SLP.NSLP END Profession, CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN POD.NAIM_PS END PODRAZD, CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN KDK6.D1_KDK6 END BEGIN_DATE, CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN KDK6.D2_KDK6 END END_DATE, CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN KDK6.KOL_DAYF END FACT_KOL_DAYS, CASE WHEN ((YEAR (KDK6.D2_KDK6) - YEAR(KDK6.D1_KDK6)<2) OR ((KDK6.D1_KDK6 IS NULL) AND (KDK6.D2_KDK6 IS NULL)))THEN(SELECT SUM(KPREZ.KOL_DAYP) FROM KPREZ WHERE YEAR(KPREZ.DATEPLWK) = '2015' AND KPREZ.N_KDK = KDK.N_KDK )END DAYS_PO_PLANY from pod, KDK inner join KDK6 on KDK6.N_KDK = KDK.N_KDK left join SLP ON SLP.KSLP = KDK.KSLP left join KDK5 ON KDK5.N_KDK = KDK.N_KDK LEFT JOIN KPREZ ON KPREZ.N_KDK = KDK.N_KDK where POD.CEH = KDK5.CEH AND KDK5.D_KDK5 IN (SELECT MAX (KDK5.D_KDK5) FROM KDK5 WHERE KDK5.N_KDK = KDK.N_KDK) GROUP BY KDK.FIO_OTV, SLP.NSLP, KDK6.D1_KDK6, KDK6.D2_KDK6 , KDK6.N_KDK, KDK.N_KDK, pod.NAIM_PS, KDK6.KOL_DAYF ORDER BY KDK.FIO_OTV
J

How I can enter date and time from java to Mysql
Software Programming • java mysql • • Jolied

2

0
Votes

2
Posts

0
Views

R

If when you do the entry you have already entered the DB, when the vehicle is gone and you make the exit, you have to make a UPDATE to the DB, not an INSERT because in that case you would be adding another row to the DB, and you're not saying what you go by car or any of the other data. Your code should be:sql = "UPDATE altavehiculos SET hora_salida = ? WHERE idVehiculo = ?"; PreparedStatement pst = cn.prepareStatement(sql); pst.setString(1,hora_salida); pst.setInt(2, idVehiculo); int n = pst.executeUpdate(); if (n > 0) { JOptionPane.showMessageDialog(null,"Se dio salida correctamente"); }
R

What is the function equivalent to the "lastval()" function of PostgreSQL in MySQL?
Software Programming • mysql postgresql • • Raziyah00

2

0
Votes

2
Posts

0
Views

A

In PostgreSQL, the function https://www.postgresql.org/docs/current/static/functions-sequence.html allows you to find the most recent auto-generate value of a column SERIAL in the context of the current session.select lastval() In MySQL, the equivalent is the function https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id which works similarly, but with columns of type AUTO_INCREMENT.select last_insert_id()

How do you create a few conditions in the trigger?

Suggested Topics

Get normalized representation of SET datatype SQL, Database Testing • mysql select mariadb • • elysha

Receipt of id for mysql Software Programming • php mysql • • Cleofas

Create a Trigger with JOIN to duplicate the data Software Programming • mysql wordpress • • Kadir

Create a list of two others on the Scala condition. Software Programming • scala • • jonetta

How do I get a SQL disposal request with a condition that there's a record on another condition? Software Programming • php mysql sql • • juvenalb

MySQL trigger help with the trigger, I want one table to be updated in another table. Software Programming • mysql trigger • • rosemadder

What kinds of protection are needed for a financial website with a balance other than protection against xss, csrf and frode attacks? Software Programming • javascript php sql security • • jonetta

Is it a good practice to have the same name with the bank name column? Software Programming • php sql databank pdo modeling • • kalena

How to create a trigger that fills the data in another table with similar fields Software Programming • sql server sql trigger • • Jolied

Triggers Software Programming • ruby • • Marcee

Create trigger for sequence in primary key Software Programming • oracle • • simrah

How to create a function that creates data for csv Software Programming • python python 3.x • • juvenalb

How do you choose the lines on the condition just so that those do not fit the condition? Software Programming • sql • • Cleofas

How I can enter date and time from java to Mysql Software Programming • java mysql • • Jolied

What is the function equivalent to the "lastval()" function of PostgreSQL in MySQL? Software Programming • mysql postgresql • • Raziyah00

Get normalized representation of SET datatype
SQL, Database Testing • mysql select mariadb • • elysha

Receipt of id for mysql
Software Programming • php mysql • • Cleofas

Create a Trigger with JOIN to duplicate the data
Software Programming • mysql wordpress • • Kadir

Create a list of two others on the Scala condition.
Software Programming • scala • • jonetta

How do I get a SQL disposal request with a condition that there's a record on another condition?
Software Programming • php mysql sql • • juvenalb

MySQL trigger help with the trigger, I want one table to be updated in another table.
Software Programming • mysql trigger • • rosemadder

What kinds of protection are needed for a financial website with a balance other than protection against xss, csrf and frode attacks?
Software Programming • javascript php sql security • • jonetta

Is it a good practice to have the same name with the bank name column?
Software Programming • php sql databank pdo modeling • • kalena

How to create a trigger that fills the data in another table with similar fields
Software Programming • sql server sql trigger • • Jolied

Triggers
Software Programming • ruby • • Marcee

Create trigger for sequence in primary key
Software Programming • oracle • • simrah

How to create a function that creates data for csv
Software Programming • python python 3.x • • juvenalb

How do you choose the lines on the condition just so that those do not fit the condition?
Software Programming • sql • • Cleofas

How I can enter date and time from java to Mysql
Software Programming • java mysql • • Jolied

What is the function equivalent to the "lastval()" function of PostgreSQL in MySQL?
Software Programming • mysql postgresql • • Raziyah00