villain villain - 19 days ago 5x
MySQL Question

How to resolve "tablename.tablename doesn't exists"?


I'm trying to create a trigger which should not allow the insert for those journey_dates which are less than the current date.


There is a difference between table and schema/database for most RDB.

You seem to use FlySafeAirways as database name, not the table name.

Figure out what is your table name. If that is 'reservation', then you should use FlySafeAirways.reservation instead of just FlySafeAirways.