edited title

Link

edited Nov 21, 2015 at 14:16

MySQL on insert in table update field in another table? [SOLVED]

added 98 characters in body; edited title

Source Link

edited Nov 21, 2015 at 11:32

SOLVED!

I used :

UPDATE Topics SET Answers = Answers + 1 WHERE ID = NEW.TopicID;

MySQL on insert in table update field in another table?

SOLVED!

I used :

UPDATE Topics SET Answers = Answers + 1 WHERE ID = NEW.TopicID;

added 241 characters in body

Source Link

edited Nov 21, 2015 at 11:14

New Problem: How I can implement this query:

UPDATE Topics SET Answers = Answers + 1 WHERE ID = TopicID;

instead of:

UPDATE Topics SET Answers = Answers + 1

Where TopicID must be TopicID of just inserted row?

New Problem: How I can implement this query:

UPDATE Topics SET Answers = Answers + 1 WHERE ID = TopicID;

instead of:

UPDATE Topics SET Answers = Answers + 1

Where TopicID must be TopicID of just inserted row?

added 3394 characters in body

Source Link

edited Nov 20, 2015 at 23:10

Loading

Source Link

asked Nov 20, 2015 at 22:52

Loading