villain villain - 1 year ago 110
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.

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download