MariaDB [(none)]> use bookbiz;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [bookbiz]> CREATE TRIGGER delcascadetrig
-> ON titles
-> FOR DELETE
-> AS
-> DELETE titleauthors
-> FROM titleauthors, deleted
-> WHERE titleauthors.title_id = deleted.title_id;
out:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the
right syntax to use near 'ON titles
FOR DELETE
AS
DELETE titleauthors
FROM titleauthors, deleted
WHERE tit' at line 2
