sql error creating trigger in sqlite

Question

I am using sqlite 2.8.17 installed on ubuntu lucid ( I used apt-get install sqlite)

I have a college table on which I tried to create a trigger(as mentioned in dbclass.org video)

create trigger R4
before insert on College
for each row
when exists (select * from College where cName = New.cName)
begin
  select raise(ignore);
end;

This causes an error

SQL error: near "select": syntax error

the schema for college is

create table College(cName text, state text, enrollment int);

If you insist :) I tried to find an authoritative reference for version 2 but, alas, no joy. I don't know what specific part of that trigger version 2 didn't like. — mu is too short
– mu is too short, Commented May 2, 2012 at 17:27

mu is too short · Accepted Answer · 2012-05-02 17:26:21Z

1

That trigger works just fine with SQLite3. Perhaps version 2 doesn't support when or triggers or has a different syntax for the trigger body. I can't find an authoritative reference for version 2 so I'm guessing.

answered May 2, 2012 at 17:26

mu is too short

436k71 gold badges863 silver badges822 bronze badges

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

Collectives™ on Stack Overflow

sql error creating trigger in sqlite

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