Posts by Amiraldo Rodrigues Filho • 39 points
7 posts
-
0
votes2
answers75
viewsA: Why are you making this mistake and how do I reverse it?
I was able to solve my problem by using a function within Trigger. a FUNCTION: delimiter // create function numpAlecrim (p1 int, p2 int, p3 int, p4 int, p5 int, p6 int, p7 int, p8 int, p9 int)…
-
0
votes2
answers75
viewsQ: Why are you making this mistake and how do I reverse it?
I have this table: create table lagoa_azul( id_lagoa_azul int not null auto_increment, sem_epi int not null, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7…
-
0
votes1
answer346
viewsQ: Relationship between 4 tables
I have the tables: -- NORTE -- create table tb_indices_norte( id_norte int not null auto_increment, localidade varchar(30), sem_epi int not null, totOvos smallint, num_pos smallint, num_inst…
-
0
votes1
answer475
viewsQ: Create Array using SELECT output
public class TelaGrafico extends javax.swing.JFrame { Connection conexao = null; PreparedStatement pst = null; ResultSet rs = null; /** * Creates new form TelaGrafico */ public TelaGrafico() {…
-
2
votes1
answer135
viewsA: What’s wrong with Rigger?
Just lack of experience myself! Follow the corrected TRIGGER: delimiter // CREATE TRIGGER somaOvosAlecrim BEFORE UPDATE ON alecrim FOR EACH ROW BEGIN IF OLD.pend > 0 THEN SET NEW.totOvos = NEW.p1…
-
0
votes1
answer135
viewsQ: What’s wrong with Rigger?
I have this table: create table alecrim( id_alecrim int not null auto_increment, sem_epi int not null, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7 smallint, p8…
-
1
votes1
answer1299
viewsQ: Create Trigger after update in the table itself and in another table
First I have a table: create table alecrim( id_alecrim int not null auto_increment, sem_epi int not null unique, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7…