Error Creating Trigger Unknown System Variable

Question

I am trying to create a trigger in mysql using the following:

CREATE TRIGGER ins_daft BEFORE INSERT ON jos_ezrealty
FOR EACH ROW BEGIN 
SET preschool = livingarea*10.76391041671
END;

When I do I get the following error:

Error
SQL query:

CREATE TRIGGER ins_daft BEFORE INSERT ON jos_ezrealty
FOR EACH
ROW BEGIN 
SET preschool = livingarea * 10.76391041671 END

MySQL said: Documentation

#1193 - Unknown system variable 'preschool'

I am trying to have the value of one field converted to square feet by multiplying by 10.76391041671. Can anyone see what I am doing wrong?

Thank you.

Bill Karwin · Accepted Answer · 2014-09-22 21:33:02Z

4

Any time you want to reference the columns of a row that fired the trigger, qualify them like NEW.column_name.

Otherwise the SET command thinks you want to set a MySQL configuration variable called preschool.

answered Sep 22, 2014 at 21:33

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

2 Comments

CDubYaa Over a year ago

I made the change and now I get this:SQL query: CREATE TRIGGER ins_daft BEFORE INSERT ON jos_ezrealty FOR EACH ROW BEGIN SET NEW.preschool = 'livingarea*10.76391041671' END MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 3

Bill Karwin Over a year ago

Each statement in the body of the trigger needs a semicolon (;) to terminate it.

Collectives™ on Stack Overflow

Error Creating Trigger Unknown System Variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related