MySQL equivalent code for this Oracle trigger

Question

CREATE OR REPLACE TRIGGER  "BI_QUIZQUES" 
  before insert on "QUIZQUES"               
  for each row  
begin   
    :NEW.QID := "QUIZQUES_SEQ".nextval; 
end; 

/
ALTER TRIGGER  "BI_QUIZQUES" ENABLE
/

Could you expand a bit on what your question is? What have you tried? What is going wrong? Are you getting an error, and if so, what error? etc.. — Emmy
– Emmy, Commented Dec 11, 2019 at 8:15

Shadow · Accepted Answer · 2019-12-11 06:59:40Z

1

The trigger does just the same as an autoincrement in mysql, so add autoincrement to the QID field in your table definition.

QID is probably a primary key in your table.

create table QUIZQUES (
QID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
...
)

edited Dec 11, 2019 at 6:59

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

answered Dec 11, 2019 at 6:38

hotfix

3,39624 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL equivalent code for this Oracle trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related